By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

Question on Replication

P: n/a
Hi,
I just went through the install notes on erserver1.2 and saw a mention
in there that every table for replication requires a integer based
column. It also states that a new column is added for every table that
is replicated.

The tables I intend to replicate already have such a column. Can the
server be configured to use these instead so that the tables on both
server remain unchanged ?

What is the overhead in using replication and what is the timing of the
replication. I have a database and we add roughly 100k records during an
update operation.

I did not find a lot of information on that except 2 small documents in
distribution. can anyone point me to the site where there is a detailed
description?

Thanks
Alex

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sun, Nov 09, 2003 at 12:59:00AM +0900, Alex wrote:

The tables I intend to replicate already have such a column. Can the
server be configured to use these instead so that the tables on both
server remain unchanged ?
Yes. I recently posted a brief discussion of how to do this to the
erserver list. The archives are available on the gborg site.
What is the overhead in using replication and what is the timing of the
replication. I have a database and we add roughly 100k records during an
update operation.
You will need lots of memory. The replication canot happen, of
course, before the transaction commits. You may find that it will
not keep up to 100k records in a single snapshot, unless you do that
infrequently.
I did not find a lot of information on that except 2 small documents in
distribution. can anyone point me to the site where there is a detailed
description?


I suggest checking the mailing list.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<an****@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.