Skip to content

Instantly share code, notes, and snippets.

@scalixte-mdsol

scalixte-mdsol/postgresql@9.6

Last active September 23, 2020 23:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save scalixte-mdsol/c45b7f2da61c45e0325796ec44d18692 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save scalixte-mdsol/c45b7f2da61c45e0325796ec44d18692 to your computer and use it in GitHub Desktop.
Download ZIP
How to install and basic configuration for postgresql@9.6
Raw
postgresql@9.6
# Install via homebrew
brew install postgresql@9.6
# Verify version information
brew info postgresql@9.6
# Verify service has not started
brew services list
# Ensure verify is linked with
brew link postgresql@9.6 --overwrite --force
# Add version to PATH
export PATH="/usr/local/opt/postgresql@9.6/bin:$PATH"
# Verify version
postgres --version
# Load
ln -sfv /usr/local/Cellar/postgresql@9.6/9.6.17/homebrew.mxcl.postgresql@9.6.plist ~/Library/LaunchAgents/
# launch the service
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql@9.6.plist
# Verify service has started
brew services list
# Verify database works with username and no password needed
psql postgres -U <user_name>
# Usefull materials
https://www.postgresql.org/download/macosx/
https://www.codementor.io/@engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb
https://itnext.io/configure-postgresql-on-your-mac-from-scratch-197f8eb4048a
https://wiki.postgresql.org/wiki/PostgreSQL_Clients#SQL_Workbench.2FJ
https://wiki.postgresql.org/wiki/PostgreSQL_Clients#pgManage
https://www.robinwieruch.de/postgres-sql-macos-setup
https://www.moncefbelyamani.com/how-to-install-postgresql-on-a-mac-with-homebrew-and-lunchy/
https://www.codementor.io/@engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb
https://gist.github.com/ibraheem4/ce5ccd3e4d7a65589ce84f2a3b7c23a3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment