Postgres Pro
Downloads
Home   >   mailing lists

pg_export_snapshot on standby side - Mailing list pgsql-hackers

From Fujii Masao
Subject pg_export_snapshot on standby side
Date
Msg-id CAHGQGwEtJCeHUB6KzaiJ6ndvx6EFsidTGnuLwJ1itwVH0EJTOA@mail.gmail.com
Whole thread Raw
Responses Re: pg_export_snapshot on standby side  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
Hi,

We cannot run parallel pg_dump on the standby server because
pg_export_snapshot() always fails on the standby. Is this the oversight
of parallel pg_dump or pg_export_snapshot()?

pg_export_snapshot() fails in the standby because it always assigns
new XID and which is not allowed in the standby. Do we really need
to assign new XID even in the standby for the exportable snapshot?

Regards,

-- 
Fujii Masao

pgsql-hackers by date:

Previous
From: Benedikt Grundmann
Date:
Subject: Re: streaming replication, "frozen snapshot backup on it" and missing relfile (postgres 9.2.3 on xfs + LVM)
Next
From: Simon Riggs
Date:
Subject: Re: Fast promotion failure