From: | "Giampaolo Tomassoni" <g(dot)tomassoni(at)libero(dot)it> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | R: Per-server univocal identifier |
Date: | 2006-06-17 23:26:21 |
Message-ID: | NBBBIHMOBLOHKCGIMJMDCEJFFHAA.g.tomassoni@libero.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> ...omissis...
>
> Perhaps inet_server_addr() and inet_server_port() would answer. These
> aren't super-useful on local connections, however.
No, infact. Mine are local cons...
> How "immutable" do you want it to be exactly? The system_identifier
> embedded in pg_control might be interesting if you want something that
> will change at initdb.
The same immutability of a 'host -f' would be fine to me.
> I don't think there's a way to look at that from
> SQL but you could write a C function to access it.
I would prefer to avoid writing an external module: that way I would have to put more administration effort when upgrading the postgres installation.
Well, I'll resort probably to put a unique value in a table.
Or... Can I put a custom variable in pgsql.conf?
-----------------------------------
Giampaolo Tomassoni - IT Consultant
Piazza VIII Aprile 1948, 4
I-53044 Chiusi (SI) - Italy
Ph: +39-0578-21100
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-06-17 23:26:22 | Re: Per-server univocal identifier |
Previous Message | Tom Lane | 2006-06-17 23:12:47 | Re: Per-server univocal identifier |