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.
