On Fri, May 18, 2012 at 3:57 AM, Joshua Berkus <josh@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
reasonto do this, we should simply error out on startup if someone sets things up that way. How can we detect that
we'veconnected 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