Re: Fixing flat user/group files at database startup

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Fixing flat user/group files at database startup
Дата
Msg-id 20050205225341.GM10437@ns.snowman.net
обсуждение исходный текст
Ответ на Re: Fixing flat user/group files at database startup  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Fixing flat user/group files at database startup  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > We can't build the files very easily during WAL recovery, but
> > what about if we compare the files to the database after the normal
> > backend startup?  If they're different, regenerate the files.
>
> This assumes that you can get in in the first place, which is not a good
> assumption if the flat password file is missing all your current users
> and/or passwords.

I was thinking of this just being a general 'check that the world is
sane' part of backend startup and would be automated and happen every
time, not something an admin would have to kick off or anything.  The
backend looks through the WAL files and whatnot during startup too, to
check if there was a crash or something...

I guess I'm confused by 'who' needs to 'get in' to have a bit of code
run at the very end of the backend startup.  Apparently I'm somewhat
naive in that area.
Stephen

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Cross column statistics
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: libpq API incompatibility between 7.4 and 8.0