[postgis-users] Update data in PostGIS database

[Morten Sickel]

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
>