Re: determining when a database was created

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: determining when a database was created
Дата
Msg-id 7024.1085978260@sss.pgh.pa.us
обсуждение исходный текст
Ответ на determining when a database was created  (Ian Lipsky <postgres@merk.caltech.edu>)
Список pgsql-admin
Ian Lipsky <postgres@merk.caltech.edu> writes:
> is there a way to tell when a database was created?

Nope, PG doesn't record that anywhere.

You could get an upper bound by looking for the oldest file mod time in
the database's files.  This isn't completely reliable, but unless you're
in the habit of changing system catalogs as obscure as pg_am, it'd
probably be good enough.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Backend crash
Следующее
От: "Paul Gimpelj"
Дата:
Сообщение: [admin]@postgresql.org pg_database contents ... what happens