473,289 Members | 2,108 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Desperate help needed for Replication

I am trying to perform what I best understand as Multi-master asynchronous replication for postgres 7.3.3 servers. After researching, I tried the pgReplication project (and made the simple modification as listed in their mailing lists), but was not able to build the environment needed for Redhat 7.3.

My question is: is anyone doing this type of replication, and if you are not using pgReplicate, then what are you using?

Thank you,

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
2 1778
El Jue 23 Oct 2003 19:41, Chris M. Gamble escribió:
I am trying to perform what I best understand as Multi-master asynchronous replication for postgres 7.3.3 servers. After researching, I tried the
pgReplication project (and made the simple modification as listed in their
mailing lists), but was not able to build the environment needed for Redhat
7.3.
My question is: is anyone doing this type of replication, and if you are not

using pgReplicate, then what are you using?

1) I think the best shot should be eRServ

http://gborg.postgresql.org/project/...rojdisplay.php

2) Upgrade your DB server to 7.3.4. Your actual version has a serious bug
which can cause crashes of the system.

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués | mm******@unl.edu.ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2
On Thu, Oct 23, 2003 at 07:53:08PM -0300, Martin Marques wrote:
El Jue 23 Oct 2003 19:41, Chris M. Gamble escribi?:
I am trying to perform what I best understand as Multi-master asynchronous replication for postgres 7.3.3 servers. After researching, I tried the

1) I think the best shot should be eRServ


It most certainly would not. Erserver is good for exactly one thing
(and some people think it isn't good at this): single-master,
possibly-multi-slave asynchronous replication. Given its current
design, it will _never_ be able to do multi-master replication unless
it is "data merge" sort of stuff (e.g. table1 and table 2 on db1;
table 3 and table 4 on db2; and table1, table 2, table3, and table4
on db3).

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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Anshul Seth | last post by:
Hi All, I am currently handling a J2EE application with the Application server as Weblogic 7.0 SP2 and Database on Oracle 9.2.1.0. The client wants to setup a test environment, and as the...
2
by: Michael Orlando | last post by:
Any help would be greatly appreciated. My problem is that I need to set up a backup SQL Server 2000 machine which can be used in case of a failure to my primary. All databases (30 as of now)...
0
by: Raghuraman | last post by:
Hi , I am in sqlserver 7.0 and i tried to create a publication( Data Replication).I choosed snapshot type . after all if i give finish , My server tells the folwing errors Sql server E.M...
7
by: Andy K | last post by:
Hi , I have an existing database (on a Linux Red Hat ES3) where the replication function exists but does not work because the target database has been shutdown months ago . My question is...
6
by: John | last post by:
Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops...
56
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving...
9
by: David W. Fenton | last post by:
See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4...
2
by: Jim | last post by:
I work in the environmental industry and we have large gcms instruments that aquire raw data to an attached computer. These computers are networked, and have shared folders so the data can be...
1
by: transnet | last post by:
have two servers, currently running Red Hat Enterprise (EL3) with 6 hard drives each 2 for OS (mirror) 2 for data (mirror) and 2 for Mysql DB (mirror) both are identical. now without spending...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.