Installing Postgres via Brew (OSX)

postgres-brew.md

Installing Postgres via Brew

Pre-Reqs

Brew Package Manager

In your command-line run the following commands:

1. brew doctor
2. brew update

Installing

1. In your command-line run the command: brew install postgres

2. Configuration can be found in this file: /usr/local/opt/postgresql/homebrew.mxcl.postgresql.plist

3. Create new aliases to start and stop postgres server (in .bachrc/.zshrc/etc.):

   alias pg_start="brew services start postgresql"
   alias pg_stop="brew services stop postgresql"
   

4. Run the aliases:

• to start database service

  $ pg_start
  

• to check if database service running or not:

  $ brew services list
  

  OR

  $ ps aux | grep postgres
  

• to stop database service.

  $ pg_stop
  

5. Connect to database postgres with psql

   $ psql postgres
   psql (14.1)
   Type "help" for help.
   
   postgres=# 
   

6. createuser -s postgres - fixes role "postgres" does not exist

7. Create database: createdb `whoami`

Optional Configurations:

1. Change data directory (DATADIR):

• In the file "/usr/local/opt/postgresql/homebrew.mxcl.postgresql.plist"

• Change the default location, value after option -D, to a custom directory, e.g. "/Users/abc/postgres":

  <key>ProgramArguments</key>
  <array>
     <string>/usr/local/opt/postgresql/bin/postgres</string>
     <string>-D</string>
     <string>/Users/abc/postgres</string>
  </array>
  

• Directoy "/Users/abc/postgres" must have either permission u=rwx (0700) or u=rwx,g=rx (0750):

  $ chmod 0750 /Users/abc/postgres
  

2. Change log file directory:

   <key>StandardErrorPath</key>
   <string>/usr/local/var/log/postgres.log</string>
   <key>StandardOutPath</key>
   <string>/usr/local/var/log/postgres.log</string>