Sep 19, 2017
Connect to the default database with user postgres : sudo -u postgres psql template1 Set the password for user postgres, then exit psql (Ctrl-D) : ALTER USER postgres with encrypted password 'xxxxxxx'; Edit the pg_hba.conf file:sud...
May 26, 2016
Introduction PostgreSQL 9.4 was released on 12/18/2014. More information about the release is available on the official PostgreSQL documentation.This article is written to provide an easy migration solution from PostgreSQL 9.3 to 9.4 for Debian s...
Apr 05, 2016
Connecting for the first time sudo -u postgres psql Set the password \password postgres Logging in psql -h localhost -p <port no> -U <username> <database name> Commands list \h help on SQL commands \? help on psql com...