[OSGeo-Discuss] database replication

[carlos sousa]

Thank you,

I'm gonna check it out

On Mon, Jul 6, 2009 at 5:08 PM, Jo Cook <j.cook at 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" <springaleek at 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 at 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 at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/discuss/attachments/20090706/2ed36f69/attachment-0002.html>