Re: user privilages for executing pg_autovacuum?
От | Zlatko Matić |
---|---|
Тема | Re: user privilages for executing pg_autovacuum? |
Дата | |
Msg-id | 008801c5cf0c$e1f5b2a0$52bffea9@zlatkovyfkpgz6 обсуждение исходный текст |
Ответ на | user privilages for executing pg_autovacuum? (Zlatko Matić <zlatko.matic1@sb.t-com.hr>) |
Список | pgsql-general |
OK. but, is it required that the user is a superuser, owner of tables or just needs to have select rights on tables? Thanks, Zlatko ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr> Cc: "Matthew T. O'Connor" <matthew@zeut.net>; <pgsql-general@postgresql.org> Sent: Tuesday, October 11, 2005 8:39 PM Subject: Re: [GENERAL] user privilages for executing pg_autovacuum? > =?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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
В списке pgsql-general по дате отправления: