Hi Carlos, I wrote that round-up, and there are a couple of things I would add. The first is that, of the packages I talk about in that blog post, I'd go with dbreplicator as it seems a little more active in terms of development and response to emails. However, these days I would actually choose sqlsync http://silvercoders.com/index.php?page=sqlsync
This works very well as a cross-platform (cross-database too) command line tool, so once you're familiar with the syntax it can easily be incorporated into a script to run whenever you need it to. Hope that helps Jo Chris Puttick wrote: > > This might help: > > http://www.archaeogeek.com/blog/2008/11/21/database-replication/ > > Regards > > Chris > > ----- "carlos sousa" <springal...@gmail.com> wrote: > >> 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 >> _______________________________________________ >> Discuss mailing list >> Discuss@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/discuss > > > ------ > Files attached to this email may be in ISO 26300 format (OASIS Open > Document Format). If you have difficulty opening them, please visit > http://iso26300.info for more information. > > _______________________________________________ > Discuss mailing list > Discuss@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/discuss > > -- View this message in context: http://n2.nabble.com/database-replication-tp3211446p3213862.html Sent from the OSGeo Discuss mailing list archive at Nabble.com. _______________________________________________ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
