Synchronization Master -> Slave (on slow connetion)
От | Edson Richter |
---|---|
Тема | Synchronization Master -> Slave (on slow connetion) |
Дата | |
Msg-id | BLU0-SMTP170E9FDA4E4617E4C69F53ACFD90@phx.gbl обсуждение исходный текст |
Ответы |
Re: Synchronization Master -> Slave (on slow connetion)
|
Список | pgsql-general |
I've serious problems with slow link between continents, and twice a week I have to manually reestablish the slave, by running the following script: ------------------------------------------------------------------------------------------------------------------------------------------ psql -c "SELECT pg_start_backup('standby_sync', true)" rsync --progress -a ${PGDATA}/* root@server2.mycompany.com:/opt/pgsql/slave1/ --exclude postmaster.pid --exclude postgresql.conf --exclude pg_hba.conf --exclude pg_log --exclude pg_xlog psql -c "SELECT pg_stop_backup()" ------------------------------------------------------------------------------------------------------------------------------------------ Point is not to analyze the connection issues between the continents, but if there is a way better to synchronize these servers, and avoid to transport 8Gb of data between them when syncronizing. The rsync above can be optimized? Both servers are CentOS 5 with OpenVPN established between them (this is one of the problems: the VPN keep falling several times a day, and then finally, the sender and receiver process just vanish in the air - and I had no time to investigate the vanishment). Thanks in advance for your help,
В списке pgsql-general по дате отправления: