Thank you, i will try you solution and come back to you later. Cheers
On Mon, Jun 3, 2013 at 1:41 PM, Morten Sickel <[email protected]> wrote: > Ahh, I see. You may still use log-shipping, transfering the xlog-files on > a flash-disk, but it is probably just as easy to do an entire dump/restore > cycle. > > (on my servers (running ubunto 1204, I have pg_basebackup, pg_dump, > pg_dumpall and pg_restore which may be usesd - or you may do on the > "master": > > cd $POSTGRESDATADIRECTORY > psql -c "SELECT pg_start_backup('label', true)" > rsync -a ${PGDATA}/ $USBDRIVE --exclude postmaster.pid > psql -c "SELECT pg_stop_backup()" > > > then on the slaves > stop the postgres server > copy the files from the usb into the data directory > start the postgres server > > ) > > Morten > > > thomas lechauve skrev: > > 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 > > > > > _______________________________________________ > 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
