Re: [GENERAL] Replication options in Postgres

2000-07-31 Thread Ian Turner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > 1. In my PHP code, I have functions like > inserttransaction(values...). I could just modify inserttransaction() > so that it runs the same query (the INSERT) on two or more DB > servers. This would probably work ok. Why not have a proxy server t

Re: [GENERAL] Replication options in Postgres

2000-07-31 Thread Chris Bitmead
I guess if you don't do deletes then something like selecting all the records with an oid greater than the last replication cycle would find the most recent additions. Erich wrote: > > I am setting up a system that processes transactions, and it needs to > be highly reliable. Once a transact