Export / Import PostgreSQL database

Export a database

su - postgres
pg_dump <database_name> > database_name.pgdump

Import a database

cat database_name.pgdump | psql -d database_name


For all database

pg_dumpall -o > db_all.out
psql -e template1 < db_all.out