Re: pg_hotbackup how to

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_hotbackup how to
Date: 2008-10-14 06:21:07
Message-ID: 48F43A53.8090203@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

paulo matadr wrote:
> I have 3 database in my cluster , and would make backup online just
> one database ,atually i using pg_hotbackup
> --backupdir=/var/lib/pgsql/backups --datadir=/var/lib/pgsql/data
> but this command make a full backup in cluster.

All databases share the same write-ahead log files and other
infrastructure, so you can't take a hot backup of just one of them. Back
them all up together, use pg_dump instead, or separate the database of
interest out into a separate cluster.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2008-10-14 06:33:21 OR or IN ?
Previous Message Darren Weber 2008-10-14 02:55:58 Re: postgres user account on OSX