Re: user privilages for executing pg_autovacuum?
От | Zlatko Matić |
---|---|
Тема | Re: user privilages for executing pg_autovacuum? |
Дата | |
Msg-id | 008a01c5ce81$a379d1e0$52bffea9@zlatkovyfkpgz6 обсуждение исходный текст |
Ответ на | user privilages for executing pg_autovacuum? (Zlatko Matić <zlatko.matic1@sb.t-com.hr>) |
Ответы |
Re: user privilages for executing pg_autovacuum?
|
Список | pgsql-general |
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 ? Thanks, Zlatko ----- Original Message ----- From: "Matthew T. O'Connor" <matthew@zeut.net> To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr> Cc: <pgsql-general@postgresql.org> Sent: Tuesday, October 11, 2005 4:00 PM Subject: Re: [GENERAL] user privilages for executing pg_autovacuum? Zlatko Matić wrote: > For pg_dump minimum privilages is to have select right on tables. > For vacuumdb, one must be owner of tables or a superuser. > What are minimum rights for user that is trying to execute pg_autovacuum > ? Not sure exactly, you need to have permission to vacuum every table in the database including system tables. > How can I monitor vacuuming by pg_autovacuum ? It logs all its activity if you set the debug option to an appropriate level. Try -d1 or -d2. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
В списке pgsql-general по дате отправления: