Asyncron replication from wan to lan with PostgreSQL 8

From: Sebastian Hennebrueder <usenet(at)laliluna(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Asyncron replication from wan to lan with PostgreSQL 8
Date: 2005-04-11 10:05:37
Message-ID: 425A4BF1.8060204@laliluna.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am trying to find a solution for the following case:
replicate the database from a web application on our Internetserver
(master) to a local database (slave) in our LAN with a local IP
address. We want to replicate only a few tables creates specially for
reports.
- the master cannot connect to the slave directly
- the slave must start the request
- synchronisation takes place periodically

Solutions I found but that did not help for this case

Slony
expects slaves to be reachable from the masters
syncronious replication

http://www.commandprompt.com/products/mammothreplicator/
asyncronious replication available, so technically this could work
compression, ssl connections
but expects postresql 7.4
Linux only

Daffodil replicator
asyncronious replication available,
push, pull, snapshot and syncronisation
but we had issues as the master is trying to connect to the slave, this
is not possible in a connection to a local IP address.

http://c-jdbc.objectweb.org/
very easy when using Java what we are doing
but expects slave to be reachable

Only solution expect to work at the moment
Do it by foot (as we say in Germany)
Trigger to list IDs in a syncronisation table.
Query from a local application selecting the data for the ids and
updating the data in the local database

Are there any other solutions than doing the syncronisation manually?

--
Kind Regards / Viele Grüße

Sebastian Hennebrueder

-----
http://www.laliluna.de/tutorials.html
Tutorials for Java, Struts, JavaServer Faces, JSP, Hibernate, EJB and more.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2005-04-11 10:07:05 Re: Time and date functions give me headaches!!
Previous Message Costin Manda 2005-04-11 10:00:43 Re: What are the consequences of a bad database design