do the files in pg_xlog differ in master and slave?

From: Kent Tong <kent(dot)tong(dot)mo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: do the files in pg_xlog differ in master and slave?
Date: 2012-08-29 11:19:00
Message-ID: CAKs98dHoF7Lzi0TU+7-EtfEaw9YLxSf4f6SbN9S6D7iGZsMteg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

The documentation seems to say that when setting up a standby, it is OK to
rsync/copy the files from the master, but the pg_xlog directory should be
excluded. Is there some important difference between the files in pg_xlog
in the master and those in the slave? If so, what is it? If the pg_xlog
files are copied, would it cause the "timeline xx of the primary does not
match recovery target timeline yy" error? Why?

Thanks!

--
Kent Tong
IT author and consultant, child educator

Browse pgsql-general by date

  From Date Subject
Next Message Bartosz Dmytrak 2012-08-29 12:15:02 Re: Dropping all foreign keys for a column in a table
Previous Message Sergey Konoplev 2012-08-29 08:55:34 Re: order of checking the unique constraints