Andrew Sullivan ajs
Sun Jan 29 14:57:53 PST 2006
On Sun, Jan 29, 2006 at 11:31:51AM -0800, ML mail wrote:
> Hello,
>  
>  I was reading throught the documentation of Slony-I and it is
>  always speaking of replication 1 single database. I have many
>  databases in one PostgreSQL engine for different purposes
>  (especially for websites virtualhost). Is it somehoe possible to
>  tell Slony-I to replicate ALL the databases ?

No.  You need a different daemon for each.  You might find that you
could reproduce your many-database approach with a many-schema
approach.  You could use one Slony instance for that.


>  Also I was reading in the documentation that for replication to
>  work successfully, every tables needs to have a primary key, is
>  this correct ?

A candidate primary key, yes.

A


-- 
Andrew Sullivan  | ajs at crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?
		--attr. John Maynard Keynes



More information about the Slony1-general mailing list