Re: pgsql password when FreeBSD boots -- what's usual?

Поиск
Список
Период
Сортировка
От Sean Chittenden
Тема Re: pgsql password when FreeBSD boots -- what's usual?
Дата
Msg-id 20030403062908.GF64139@perrin.int.nxad.com
обсуждение исходный текст
Ответ на Re: pgsql password when FreeBSD boots -- what's usual?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pgsql password when FreeBSD boots -- what's usual?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> > I personally find the behavior of pg_ctl connecting to the
> > postmaster _after_ it's started up to verify that it has indeed
> > started up, to be a rather broken behavior and think that it
> > shouldn't be the default.
>
> ??  It isn't.
>
> I agree that we could do with a better mechanism, though.

Hrm, I stand corrected.  The startup script passes -w.  Hrm, idea.
Any chance the PID filename could be hard linked to the format:
postmaster-%d.pid where %d is the start time of the postmaster?
Cleanup would have to be altered to remove both files, and the
postmaster would have to be updated to retain the time at which it
started.  Anyway, my thought being that the new and upcoming protocol
could include an uptime query that'd include the time that the server
was started and compare it with the pid file.  Odds are slim that
they'd be the same and it'd allow for verification that the server had
started without authentication using hard to replicate, insecure data.
-sc

--
Sean Chittenden


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

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: unable to dump database, toast errors
Следующее
От: Muhammad Shariq
Дата:
Сообщение: Re: row-level locking