Postgres Pro
Downloads
Home   >   mailing lists

Re: Streaming replication with sync slave, but disconnects due to missing WAL segments - Mailing list pgsql-general

From Jeff Janes
Subject Re: Streaming replication with sync slave, but disconnects due to missing WAL segments
Date
Msg-id CAMkU=1yCrvfHCgckh3qjVE87k1tAZZGOka-n-htm81MAEgPw5A@mail.gmail.com
Whole thread Raw
In response to Streaming replication with sync slave, but disconnects due to missing WAL segments  (Mads.Tandrup@schneider-electric.com)
Responses vacuum_cost_delay and autovacuum_cost_delay  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
Re: Streaming replication with sync slave, but disconnects due to missing WAL segments  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view
On Tue, Jun 4, 2013 at 6:25 AM, <Mads.Tandrup@schneider-electric.com> wrote:

Hi all

I have a question about sync streaming replication.

I have 2 postgresql 9.1 servers set up with streaming replication. On the
master node the slave is configured as a synchronous standby. I've verified
that pg_stat_replication shows sync_state = sync for the slave node.

It all seems to work fine. But I have noticed that sometimes when I restore
backups created by pg_dump. The slave node will disconnect with the message
in the postgresql log:

You cannot use pg_dump to set up a database for receiving streaming replication.

For that it must be a physical copy, not a logical copy which is what pg_dump generates.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Keith Fiske
Date:
Subject: Re: Foreign Key violated
Next
From: Mike Summers
Date:
Subject: View's plan not taking advantage of WHERE?