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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073