| From: | David Johnston <polobo(at)yahoo(dot)com> |
|---|---|
| To: | Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au> |
| Cc: | Jaime Casanova <jaime(at)2ndquadrant(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: repmgr problem with registering standby |
| Date: | 2011-08-02 02:16:05 |
| Message-ID: | 84553DDE-1004-4A40-99EC-B60F6CF1C2C5@yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | senthilnathan | 2011-08-02 05:59:15 | Timeline Conflict |
| Previous Message | Toby Corkindale | 2011-08-02 01:45:10 | Re: repmgr problem with registering standby |