I've two distant servers I would like to configure async replication
between.
Servers are running 9.2.4.
Since 9.0 days I do use script with rsync for transfer. And sometimes
the servers get out of sync (due large processing in master database and
huge network latency), and I have to reinitialize the standby server.
Lately , this script take about an hour to copy all data (23GB) over the
standby server, and I would like to know if there is a more efficient
way (perhaps, using pg_basebackup?) to reinitilize the standby server.
I've look in wiki pages and also pg_basebackup, but information on how
to get data transfered to the remote standby server is vague.
Or should I run pg_basebackup from standby server, and the PostgreSQL
protocol is more efficient than rsync?
Thanks,
Edson