From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Giampaolo Tomassoni <g(dot)tomassoni(at)libero(dot)it> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Per-server univocal identifier |
Date: | 2006-06-17 23:26:22 |
Message-ID: | 44948F9E.40603@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I assume by 'univocal' you mean unequivocal.
Can you set it up in a table per server? or in a file? or would you
rather use a guuid?
And how is this to be made available?
And is it to be unique per machine, or per cluster (since you can have
many postgresql clusters on one machine).
cheers
andrew
Giampaolo Tomassoni wrote:
>Dears,
>
>I'm looking for a way to univocally identify the server on which a sql function or statement is running. My idea would be something close to the value returned by a 'host -f' under linux: the FQDN of the host, but even a serial code or a number would be fine to me. It needs only to be immutable, I guess.
>
>I know there is something suitable under Oracle and, even worse, under mysql...
>
>The purpose is mostly related to a light replication problem I have, in which I need to 'emulate' a multi-master replication on a table.
>
>I placed a question on the IRC list and I found a couple of unreplied messages asking the same thing in the pgsql-general list.
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-06-17 23:32:48 | Re: Per-server univocal identifier |
Previous Message | Giampaolo Tomassoni | 2006-06-17 23:26:21 | R: Per-server univocal identifier |