> For that matter - is there a reason it has to be an integer? Allowing hostnames there would be more friendly. Using integers means 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 sense to use a varchar instead of an integer but it seems people treat such a key type as forbidden. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
