On Tue, Jun 4, 2013 at 6:25 AM, <mads.tand...@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
