Greg Sabino Mullane on 20 Jan 2008 17:16:08 -0800


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

Re: [PLUG] Crosspost: PostgresSQL replication?


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


> Sorry, there was one point I forgot to mention: This code we got is
> tough to change and does not have a primary key in every table, which
> Slony requires, so Slony is out for us.

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

> I will check that out. Thanks! :)

Don't get too far - it also requires a primary key (or, more specifically,
some sort of unique key).

The solution you need depends on what you are trying to achieve with
replication. This page may help:

http://developer.postgresql.org/index.php/Replication,_Clustering,_and_Connection_Pooling

You might also try #postgresql on irc.freenode.net.

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

iD8DBQFHk/I5vJuQZxSWSsgRA2ktAJ9prwQmHYNeoBu35pvCJCBYDJykcgCgy7F+
9SekookwsD+CmLIBi2jXEcs=
=rsNk
-----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