Admin
Sep 19, 2017
17 comments
751
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...
Snippet
How to configure postgresql for the first time?
Admin
Sep 19, 2017
2 comments
179
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...
Snippet
How to configure postgresql for the first time?
Admin
Sep 19, 2017
11 comments
969
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...
Snippet
How to configure postgresql for the first time?
Admin
Sep 19, 2017
22 comments
924
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...
Snippet
How to configure postgresql for the first time?
Admin
May 26, 2016
19 comments
216
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...
Snippet
Migrating from PostgreSQL 9.3 to 9.4
Admin
May 26, 2016
8 comments
645
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...
Snippet
Migrating from PostgreSQL 9.3 to 9.4
Admin
May 26, 2016
22 comments
580
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...
Snippet
Migrating from PostgreSQL 9.3 to 9.4
Admin
May 26, 2016
1 comments
609
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...
Snippet
Migrating from PostgreSQL 9.3 to 9.4
Admin
Apr 05, 2016
15 comments
912
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...
Snippet
PostgreSQL psql console commands
Admin
Apr 05, 2016
23 comments
303
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...
Snippet
PostgreSQL psql console commands