|
Home > Archive > Slony1 PostgreSQL Replication > January 2006 > Replicating all databases with Slony-I
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Replicating all databases with Slony-I
|
|
| ML mail 2006-01-29, 8:24 pm |
| 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 ?
Also I was reading in the documentation that for replication to work successfully, every tables needs to have a primary key, is this correct ?
Many thanks for the help
Regards
---------------------------------
What are the most popular cars? Find out at Yahoo! Autos
| |
| Andrew Sullivan 2006-01-29, 8:24 pm |
| 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-oaT0K0jot5/q2IAV+ODieA@public.gmane.org
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
| |
|
|
|
|
|