[Cialug] Postgres backup

[L. V. Lammert]

On Tue, 24 Jul 2012, L. V. Lammert wrote:

> su - postgres
> pg_dumpall > /home/db_backup/db.sql
> gzip -f /home/db_backup/db.sql
> exit
>
> How does one properly dump a PG environment?
>
Appears that postgres is pretty picky in how it determines the current
Role - passing as a parameter works:

/usr/bin/pg_dumpall -U postgres -f /var/backups/pg_db.dump
gzip -f /var/backups/pg_db.dump

Sorry for the noise!

	Lee