[postgis-users] Update data in PostGIS database

[thomas lechauve]

Unfortunately, servers cannot communicate. "client" servers are not
connected to a network, they work in standalone, so i have to use an usb
drive to transport backup file, then restore it.


On Mon, Jun 3, 2013 at 1:12 PM, Morten Sickel <morten at sickel.net> wrote:

> It depends a bit...
>
> If those servers are able to communicate with each other on port 5432, you
> can use streaming replication to make one of the servers being a (read
> only) mirror of the other. - or you may set up log-shipping streaming
> replication, in which case te master server only needs to be able to send
> files (i.e. using rsync) to the slave server.
>
> In both cases, the servers must be identical - same versions and the same
> databases - which all are read only on the slave... (You may of course run
> more postgres servers on the slave, where one is dedicated to the
> OSM-data.)
>
> Just ask me if you need some assistance, I have set up a few
> streaming-replication and log-shipping replication servers.
>
> Morten
>
> thomas lechauve skrev:
> > Hello,
> >
> > I am trying to synchronize two PostGIS databases.
> >
> > I have a reference server which is filled and updated every day with OSM
> > data. For this purpose I recreate the whole database. But now i want to
> > update another database which is not on the same server based on the
> first
> > database without recreate it.
> >
> > pg_dump/pg_restore tools are probably what i am looking for, but i cannot
> > find a way to achieve my purposes.
> >
> > Do i have to keep trying with those tools or is there another way ?
> >
> > Perhaps a SQL script could do it but i want to avoid it because i am no
> > expert in PostGIS and databases in general.
> >
> > Any recommendations ?
> >
> > Cheers
> >
> > --
> > Thomas LECHAUVE
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> >
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
Thomas LECHAUVE
portable : +33 6 51 21 07 40
fixe : +33 9 82 37 41 94
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130603/0bca989e/attachment.html>