Re: user privilages for executing pg_autovacuum? - Mailing list pgsql-general

From Zlatko Matić
Subject Re: user privilages for executing pg_autovacuum?
Date
Msg-id 008801c5cf0c$e1f5b2a0$52bffea9@zlatkovyfkpgz6
Whole thread Raw
In response to user privilages for executing pg_autovacuum?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
List 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 by date:

Previous
From: Sergey Karin
Date:
Subject: problem with bit(n) type
Next
From: Neil Dugan
Date:
Subject: Re: License question[VASCL:A1077160A86]