Postgres Pro
Downloads
Home   >   mailing lists

do the files in pg_xlog differ in master and slave? - Mailing list pgsql-general

From Kent Tong
Subject do the files in pg_xlog differ in master and slave?
Date
Msg-id CAKs98dHoF7Lzi0TU+7-EtfEaw9YLxSf4f6SbN9S6D7iGZsMteg@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: order of checking the unique constraints
Next
From: Bartosz Dmytrak
Date:
Subject: Re: Dropping all foreign keys for a column in a table