Re: pg_upgrade using appname to lock out other users

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_upgrade using appname to lock out other users
Дата
Msg-id 201106170347.p5H3ldg18975@momjian.us
обсуждение исходный текст
Ответ на Re: pg_upgrade using appname to lock out other users  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: pg_upgrade using appname to lock out other users  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas wrote:
> > We can pick different options for 9.0, 9.1, and 9.2. ?(For PG 9.0
> > probably only #1 is appropriate.)
> 
> I don't like any of these options as well as what I already proposed.
> I proposed a complicated approach that actually fixes the problem for
> real; you're proposing a whole bunch of simpler approaches all of
> which have pretty obvious holes.  We already have something that only
> sorta works; replacing it with a different system that only sorta
> works is not going to be a great leap forward.

What is your proposal?  Write a password into a file that is read by the
postmaster on startup and used for connections?  That would remove the
"modify pg_hba.conf to 'trust'" step, but again only for new servers.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [GENERAL] Issues with generate_series using integer boundaries
Следующее
От: Robert Haas
Дата:
Сообщение: Re: SSI work for 9.1