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:35:37 |
Message-ID: | NBBBIHMOBLOHKCGIMJMDAEJGFHAA.g.tomassoni@libero.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> I assume by 'univocal' you mean unequivocal.
Yes, sorry about that: I'm writing italish...
> Can you set it up in a table per server? or in a file? or would you
> rather use a guuid?
A per-server table will probably be my way.
> And how is this to be made available?
Well, a function would be fine.
> And is it to be unique per machine, or per cluster (since you can have
> many postgresql clusters on one machine).
If it is a per-machine discriminator, it will be a per-node discriminator as well...
Also, it will be useful to people not running a cluster (like me), since they only need a multi-master capability on a table for a legacy app...
> cheers
>
> andrew
Cheers,
giampaolo
>
> 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.
> >
> >
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2006-06-18 02:46:04 | Re: Rethinking stats communication mechanisms |
Previous Message | Tom Lane | 2006-06-17 23:32:48 | Re: Per-server univocal identifier |