Thank you, I'm gonna check it out
On Mon, Jul 6, 2009 at 5:08 PM, Jo Cook <j.c...@oxfordarch.co.uk> wrote: > > 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 >
_______________________________________________ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss