Hello, I have a multi-terabyte streaming replica on a bysy database. When I set it up, repetative rsyncs take at least 6 hours each. So, when I start the replica, it begins streaming, but it is many hours behind right from the start. It is working for hours, and cannot reach a consistent state so the database is not getting opened for queries. I have plenty of WAL files available in the master’s pg_xlog, so the replica never uses archived logs. A question: Should I be able to run one more rsync from the master to my replica while it is streaming? The idea is to overcome the throughput limit imposed by a single recovery process on the replica and allow to catch up quicker. I remember doing it many years ago on Pg 8.4, and also heard from other people doing it. In all cases, it seamed working. I’m just not sure if there is no high risk of introducing some hidden data corruption, which I may not notice for a while on such a huge database. Any educated opinions on the subject here?
Thank you Igor Polishchuk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
