postgresql

gistfile1.txt

xy@ubuntu:~$ sudo -u postgres psql template1
psql (9.3.4)
Type "help" for help.
template1=# \password postgres
Enter new password:

=============================================

sudo -u postgres psql
postgres-# \list

=============================================

Switch to the postgres user:
sudo su postgres

Execute the postgres createdb command:
createdb --encoding='utf-8' --locale=en_US.utf8 --template=template0;

List the databases from psql:
psql
\l

Quit back to the previous user:
exit

========================================================

pgcli postgres://postgres:pa$$w0rd@localhost:5432/testdb

========================================================

ubuntu@bigdog:~$ sudo netstat -tulpn