Greg Sabino Mullane on 20 Jan 2008 12:56:35 -0800


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] Crosspost: PostgresSQL replication?


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> We're having an issue with some code we picked up that's tied to
> PostgresSQL. This code currently does not run any kind of replication
> for its Postgres instance which we find to be unacceptable for what
> would seem to be obvious reasons. The kind of replication we'd like to
> do is master-slave asynchronous replication, which is quite simple
> using MySQL as replication is built in. We've investigated some of the
> options for Postgres replication (in particular Slony, but most others
> are pretty old) but the best we can come up with so far is
> master-slave *synchronous* backup. We'd rather not have to stop the
> master while we are backing up to the slave if possible.

Slony is asynchronous, and used in many production environments.

There's also Bucardo, which does asynchronous master-slave and
master-master, but is very new.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200801201553
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFHk7UpvJuQZxSWSsgRA8JWAJ9jl1WnR+0shYtJKv3r4v7L4ud85gCg3WWx
IrLnk6HybqkwJtMq406l/XQ=
=cXm6
-----END PGP SIGNATURE-----


___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug