On Fri, May 18, 2012 at 3:57 AM, Joshua Berkus <j...@agliodbs.com> wrote: > Yeah, I don't know how I produced the crash in the first place, because of > course the self-replica should block all writes, and retesting it I can't get > it to accept a write. Not sure how I did it in the first place. > > So the bug is just that you can connect a server to itself as its own > replica. Since I can't think of any good reason to do this, we should simply > error out on startup if someone sets things up that way. How can we detect > that we've connected streaming replication to the same server?
It might be easy to detect the situation where the standby has connected to itself, e.g., by assigning ID for each instance and checking whether IDs of two servers are the same. But it seems not easy to detect the circularly-connected two or more standbys. Regards, -- Fujii Masao -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
