At 02:41 PM 9/20/04, Eduardo Vázquez Rodríguez wrote:
>How do I make a backup of a database in a different partition?, for
>instance /home/postgres
This works for me (replace [database] with name of your database):
pg_dump -o -c [database] | gzip > /home/postgres/[database].`date
+\%Y\%m\%d`.gz
Frank