Unfortunately, the only syncronous replication I know of is http://pgfoundry.org/projects/pgcluster/, which is statement-based. That means it's got some substantial drawbacks... On Fri, Oct 21, 2005 at 11:28:36AM -0500, Kirby Ubben wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > We have installed a product called Quasar for accounting needs at our > company, which is back ended by PostgreSQL. It is a requirement that > the database is replicated, real time, to a secondary machine and > PostgreSQL database, in case of failure of the first. > > Currently i have Slony working, but am not satisfied with how it > accomplishes replication, or it's interface, and am curious what > others are using to accomplish replication? > > Thanks in advance, > > k. > > - -- > Kirby Ubben > Systems Engineer > McMurray Hatchery > kirby@xxxxxxxxxxxxxxxxxxxx > > 1 515 832 1235 ext 201 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFDWRc0thkzRAQDSgERAhSrAJ9Ax5nwDMlOUiRw8jcczmU7PJo8LgCeMf3a > gIFKb7oH7+4zuAEZyQYowh0= > =CIAC > -----END PGP SIGNATURE----- > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
