> ...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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
