Re: user privilages for executing pg_autovacuum?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: user privilages for executing pg_autovacuum?
Дата
Msg-id 17692.1129055964@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: user privilages for executing pg_autovacuum?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
Ответы Re: user privilages for executing pg_autovacuum?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-general
=?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@sb.t-com.hr> writes:
> That's the reason why I ask. If a user that executes pg_autovacuum must be
> owner of tables or a superuser, that it is a security problem to pass
> password as plain text...
> How peple solve this problem ?

Put the password in a ~/.pgpass file belonging to the user that runs the
autovacuum task.

            regards, tom lane

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: PostgreSQL's bug tracker
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: Considering an upgrade...