Sorry, here are the missing details, if it helps: Postgres 9.6.5 on CentOS 7.2.1511 > On Sep 27, 2017, at 10:56, Igor Polishchuk <ora4dba@xxxxxxxxx> wrote: > > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
