Step 1: Install Homebrew
If you don’t have Homebrew installed on your Mac, open a terminal and run the following command:
This script will install Homebrew.
Step 2: Install PostgreSQL via Homebrew
Once Homebrew is installed, you can install PostgreSQL by running:
Step 3: Start PostgreSQL
After installation, you can start PostgreSQL using Homebrew services:
This command will also set PostgreSQL to start automatically at login.
Step 4: Create Your Database and User
Access PostgreSQL Prompt:
Create a Role (User):
Create a Database:
Grant Permissions:
Exit psql:
Step 5: Verify Installation
To verify that everything is set up correctly, try connecting to the database you created:
You should be able to log in without errors.
Additional Configuration
You can configure PostgreSQL to listen on different interfaces or to adjust other settings by modifying the PostgreSQL configuration file typically found at /usr/local/var/postgres/postgresql.conf. If you need to allow remote connections, you would also adjust the /usr/local/var/postgres/pg_hba.conf file.
Summary
Now, you should have PostgreSQL installed and running on your macOS system. You can manage PostgreSQL with Homebrew services and access your databases with psql or any other PostgreSQL-compatible tool. If you need any more detailed configuration, like setting up remote access or securing your database, you may need to modify configuration files or apply additional security practices as needed.
