Postgresql

Postgresql Installation and Backup Service

• wiki
• howto1
• howto2

To backup read here. or use as user postgres:

 backup:
 pg_dumpall | gzip -c > all.dbs.out.gz

and to restore:

 gunzip all.dbs.out.gz
 psql -f all.dbs.out postgres

get list of databases and tables in Postgres

 select datname from pg_database;

or:

 \l

 \dt