pg_cheatsheet.rst

PostgreSQL 9.1 Cheatsheet

sudo su postgres

Create cluster:

pg_createcluster 9.1 main --start

Create database:

createdb mydatabase

Restore gzipped pgdump:

gunzip -c mydatabase.pgdump.gz | psql mydatabase

Restart cluster:

pg_ctlcluster 9.1 main restart

Change postgres password:

psql mydatabase
ALTER USER Postgres WITH PASSWORD '<newpassword>';

Add unaccent contrib for searches without accents or other non-ascii:

psql canubring
CREATE EXTENSION "unaccent";