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.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
