Install postgress
sudo apt-get install wget ca-certificates
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-9.4 pgadmin3
Install extensions
sudo apt-get install postgresql-contrib
Restart postgresql
sudo /etc/init.d/postgresql reload
Show available extensions
sudo su - postgres
psql
SELECT * FROM pg_available_extensions;
Importing dumps
Getting error: Peer authentication failed for user “postgres” when importing dump
see:
http://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge
No comments:
Post a Comment