Re: pg_hotbackup how to - Mailing list pgsql-general

From Craig Ringer
Subject Re: pg_hotbackup how to
Date
Msg-id 48F43A53.8090203@postnewspapers.com.au
Whole thread Raw
In response to pg_hotbackup how to  (paulo matadr <saddoness@yahoo.com.br>)
List 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

pgsql-general by date:

Previous
From: "Darren Weber"
Date:
Subject: Re: postgres user account on OSX
Next
From: Luca Ferrari
Date:
Subject: OR or IN ?