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.
