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 <[email protected]> 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 > > [email protected] > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > > > _______________________________________________ > postgis-users mailing list > [email protected] > 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
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
