Thread: Asyncron replication from wan to lan with PostgreSQL 8

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.

Hi,

I have used Daffodil replicator in a similar situation earlier.

It is necessary that master and slave database should be exposed to
each
other.

The problem might have occurred due to deployment of firewall in the
network
that is preventing the connection to establish.

The solution could be found out by using routers or any other mean so
that
master and slave servers are exposed.



Regards,
Kuldeep kumar