Get a backup from PostgreSQL

Get a backup

from local

pg_dump --username=postgres --password dbname > dbname.bak

from remote

pg_dump --host=remotehost --port=5432 --username=postgres --password --dbname=DBNAME > dbname.bak

Restore backup

with psql

psql --username=username dbname < dbname.bak

psql -U postgres -p 5432 -d DBName -f path/to/file.sql

with pg_restore

pg_restore --username=username --dbname=dbname -1 filename.dump