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: (view raw, whole thread or download thread mbox)
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 


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
Previous:From: brewDate: 2004-09-22 15:00:27
Subject: Re: Multi Database queries

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