Skip to content

Instantly share code, notes, and snippets.

@AlanGabbianelli

AlanGabbianelli/PostgreSQL_and_pgAdmin

Last active November 23, 2021 11:36
Show Gist options
  • Save AlanGabbianelli/a3dcf93154a4a84207c6d3cf3e349c75 to your computer and use it in GitHub Desktop.
Save AlanGabbianelli/a3dcf93154a4a84207c6d3cf3e349c75 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL and pgAdmin
Raw
PostgreSQL_and_pgAdmin
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