🐘 Simplified Guide to Setting Up PostgreSQL on macOS with Docker 🚢

kpndevroot — Fri, 29 Nov 2024 17:59:42 +0000

Are you struggling with PostgreSQL configuration on macOS?

If you’ve been wrestling with environment variables like these:

DATABASE_URL=postgres://myuser@host.docker.internal:5432/mydb
#OR
DATABASE_URL=postgres://myuser:myuser@127.0.0.1:5432/mydb

You’re not alone! PostgreSQL setup on macOS can feel daunting due to:

❌ Limited client tools: Unlike Linux, macOS lacks straightforward commands like createuser --interactive -P.
📖 Sparse documentation: Most PostgreSQL guides cater to Linux or Windows, leaving macOS users to figure it out on their own.

But don’t worry—we’ll walk through an easy and beginner-friendly way to set up PostgreSQL on macOS using Homebrew and Docker!🎉

🏆 Why This Guide Stands Out

✅ Clear step-by-step instructions.
🖥️ Tailored for macOS users.
📊 Real-world examples with expected outputs for verification.

Let’s dive in! 🚀

🔧 Step 1: Install PostgreSQL Using Homebrew

1️⃣ Install PostgreSQL with Homebrew:

brew install postgresql@16

2️⃣ Start the PostgreSQL service:

brew services start postgresql@16

3️⃣ Verify the service status:

brew services info postgresql@16

You should see output like this:

postgresql@16 (homebrew.mxcl.postgresql@16)
Running: ✔
Loaded: ✔
Schedulable: ✘
User: root
PID: 38646

💡 Pro Tip
If you encounter issues, restart the service:

brew services restart postgresql@16

🏗️ Step 2: Create a PostgreSQL User and Database

1️⃣ Access the PostgreSQL interactive shell:

psql postgres

Example output:

❯ psql postgres
psql (14.13 (Homebrew), server 16.4 (Homebrew))
WARNING: psql major version 14, server major version 16.
         Some psql features might not work.
Type "help" for help.

2️⃣ Create a User and Database

Create a user

CREATE USER myuser WITH PASSWORD 'user';

Expected Output:

CREATE ROLE

Create a database:

CREATE DATABASE mydb;

Expected Output:

CREATE DATABASE

Grant access:

GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser;

Expected Output:

GRANT

🔗 Step 3: Connect to Your Database

Now, let’s test the connection to ensure everything is working. Use the following command to connect:

psql -U myuser -d mydb -p 5432

Expected Output:


❯ psql -U myuser -d mydb -p 5432

psql (14.13 (Homebrew), server 16.4 (Homebrew))
WARNING: psql major version 14, server major version 16.
         Some psql features might not work.
Type "help" for help.

mydb=>

🛠️ Common Issues and Solutions

1️⃣ Connection Refused

Cause: Firewall or incorrect host.docker.internal.
Solution: Test with 127.0.0.1 or check your Docker network settings

2️⃣ Version Mismatch Warnings

Cause: Using an older psql client.
Solution: Update your client to match the server version.

🎯 What’s Next?

🔍 Explore your database.
🛠️ Start building applications.
⚙️ Configure your DATABASE_URL with host.docker.internal for Docker-based projects.

Now you’re ready to handle PostgreSQL on macOS like a pro! 🚀

If you enjoyed this guide, don’t forget to share it with your fellow developers! 🧑‍💻👩‍💻

Drop a comment below if you have questions or tips to add. Let’s make PostgreSQL configuration seamless for everyone! 🌟

🏁Unleash the Full Power of Your Laptop on Linux 🚀

kpndevroot — Thu, 22 Aug 2024 03:35:53 +0000

Are you someone who prefers raw power over battery life on your laptop? If you're tired of your system holding back to conserve energy, then this guide is for you.

Why Your Laptop Isn't Running at Full Speed

Most Linux distributions default to the powersave CPU governor. This setting helps extend battery life and keep your laptop cool, but it also limits performance. If you're a power user who demands the maximum performance from your machine, you might find this setting a bit too conservative.

How to Switch to Performance Mode

Ready to make your laptop roar? Here's how you can switch your CPU governor from powersave to performance mode.

Step 1: Check Your Current CPU Governor

First, let's see what mode your system is currently using. Open your terminal and run the following command:

cat /sys/devices/system/cpu/cpu*/cpufreq/scaling_governor

If your output looks something like this:

powersave
powersave
powersave
powersave
.
.

You're in powersave mode.

Step 2: Switch to Performance Mode

To unlock the full potential of your CPU, switch to performance mode by running the following command:

echo performance | sudo tee /sys/devices/system/cpu/cpu*/cpufreq/scaling_governor

Step 3: Verify the Change

After switching, it's a good idea to confirm that the change took effect. Run the first command again:

cat /sys/devices/system/cpu/cpu*/cpufreq/scaling_governor

If everything went smoothly, you should now see:

performance
performance
performance
performance

Step 4: Enjoy the Power

Congratulations, you've successfully switched to performance mode! Your laptop is now running at full throttle. Enjoy the extra speed and power—just be mindful of the increased energy consumption and heat.

Bonus Tip: Turbocharge Your Debian-Based Distro

If you're using a Debian-based distro and want to take your system's performance to the next level, be sure to check out this awesome repo: linuxbooster. It's packed with tools and tweaks to supercharge your Linux experience.

DEV Community: kpndevroot

🐘 Simplified Guide to Setting Up PostgreSQL on macOS with Docker 🚢

Are you struggling with PostgreSQL configuration on macOS?

🏆 Why This Guide Stands Out

🔧 Step 1: Install PostgreSQL Using Homebrew

🏗️ Step 2: Create a PostgreSQL User and Database

🔗 Step 3: Connect to Your Database

🛠️ Common Issues and Solutions

🎯 What’s Next?

🏁Unleash the Full Power of Your Laptop on Linux 🚀

Why Your Laptop Isn't Running at Full Speed

How to Switch to Performance Mode

Step 2: Switch to Performance Mode

Step 3: Verify the Change

Step 4: Enjoy the Power

Bonus Tip: Turbocharge Your Debian-Based Distro