[OSGeo-Discuss] database replication

[carlos sousa]

Kind Sirs,

Being a novice postgreSQL user, i'm currently transfering from our current
esri/arcsde/arcims/mssqlserver solution to a
postgres/postgis/mapserver/openlayers
solution.
After this is down, the real server will be using software that is
replicated in virtual machines used on external harddrives with a copy of
the real server database.
What I need to know is how should I execute a command, be it in the command
line (prefferable because of scripting) or using some kind of gui tool like
pgadminIII
to let the virtual database get in sync with the real database when the
external harddrive is connected to the real server.
I've looked up sqlworkbench (no ubuntu binary) and slony (has to be
compiled).
I'm considering asking Ricardo from the GISVM project if he is available to
help me think up a solution for this, you never know.


Thanks in advance,

Carlos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/discuss/attachments/20090706/45e1b3e3/attachment-0002.html>