> For that matter - is there a reason it has to be an integer? Allowing hostnames there would be more friendly. Using
integersmeans someone has to maintain a mapping on node IDs to hostnames in a separate place, and then that leads to
mistakes,like someone thinking the standby node (2) is the master hostname :/
>
>
As a quick observation, the host name, by itself, doesn't seem to be a candidate key. It would probably have made
senseto use a varchar instead of an integer but it seems people treat such a key type as forbidden.
David J.