Re: Backups

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: Postgresql Mailing list <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Backups
Date: 2004-09-22 16:09:33
Message-ID: 5.2.1.1.0.20040922120503.027d5b10@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

  • Backups at 2004-09-20 18:41:53 from Eduardo Vázquez Rodríguez

Browse pgsql-novice by date

  From Date Subject
Next Message malini bu 2004-09-22 16:26:24
Previous Message brew 2004-09-22 15:00:27 Re: Multi Database queries