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@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
