I did ask a similiar question previously. There doesn't seem to be any widely used replication systems for postgresql. As far as I can see. Here's my plan. 1) Nightly, shutdown the postgresql service until a complete pg_dump is obtained. 2) Move and update a second machine with the data from pg_dump. 3) Restore and make READ ONLY. 4) In the php scripts to connect to the database, have a secondary IP of the backup machine. If the primary READ/WRITE server is down, all connections from php to the server will be read only until the main server can be restored. Does this sound ok? Or are there live replication services for postgresql so I can have two servers that are READ/WRITE? Thanks. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
