Re: question about Postgresql and rsync

Tony Caduto wrote:
> Hi,
> Does anyone know if it would be safe to use rsync to mirror a Postgresql
> setup to a backup server?
>
> I need to create a exact duplicate for a disaster recovery server, the
> disaster recovery server would not be in use until the production one
> went down for
> some reason.
>
> It seems to me that if the postmaster is stopped it should be safe.
> Comments?

Yes, it is safe if the postmaster is down.  In fact our documention
recommends a trick of doing rsync while the postmaster is running, then
shutting down the postmaster just long enough to do another rsync to get
the changes into the backup.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073