Last active
November 23, 2021 11:36
-
-
Save AlanGabbianelli/a3dcf93154a4a84207c6d3cf3e349c75 to your computer and use it in GitHub Desktop.
PostgreSQL and pgAdmin
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Mac: | |
brew update | |
brew install postgresql | |
brew tap homebrew/services (if services not present) | |
brew services start postgresql | |
createdb `whoami` | |
psql postgres -c 'CREATE EXTENSION "adminpack";' | |
Download and install pgAdmin | |
Add new server | |
name: localhost | |
connect now: yes | |
host: localhost | |
port: 5432 | |
maintenance database: postgres | |
password: the one you set (blank by default) | |
username: <your username> (check with whoami) | |
Linux: | |
http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/pgadmin.html | |
http://suite.opengeo.org/docs/latest/dataadmin/pgGettingStarted/firstconnect.html#dataadmin-pggettingstarted-firstconnect |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment