Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: malini buDate: 2004-09-22 16:26:24
Subject:
Previous:From: brewDate: 2004-09-22 15:00:27
Subject: Re: Multi Database queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group