Jeff Janes wrote: > On Tue, Jun 4, 2013 at 6:25 AM, <Mads.Tandrup@xxxxxxxxxxxxxxxxxxxxxx> wrote: >> 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. I think you misunderstood - he restores a dump on the *primary* and that makes replication fall over because it cannot catch up. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
