Re: pg_system_identifier()

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: pg_system_identifier()
Дата
Msg-id alpine.DEB.2.02.1308230838480.3533@localhost6.localdomain6
обсуждение исходный текст
Ответ на pg_system_identifier()  (Vik Fearing <vik.fearing@dalibo.com>)
Ответы Re: pg_system_identifier()
Список pgsql-hackers
> After someone in IRC asked if there was an equivalent to MySQL's
> server_id, it was noted that we do have a system identifier but it's not
> very accessible.
>
> The attached patch implements a pg_system_identifier() function that
> exposes it.

Would it make sense for such identifiers be standard UUID 
(http://en.wikipedia.org/wiki/UUID)?

Should there be a UUID per cluster? and/or per database, possibly deduce 
from the cluster one? Should it be configurable, say from 
"postgresql.conf"?
  get_pg_uuid()  get_pg_uuid('template0')

Note that there is a set of uuid functions provided as a module that may 
help.

-- 
Fabien.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: PL/pgSQL, RAISE and error context
Следующее
От: Sawada Masahiko
Дата:
Сообщение: Behaviour of take over the synchronous replication