From: | Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: user privilages for executing pg_autovacuum? |
Date: | 2005-10-12 09:11:08 |
Message-ID: | 008801c5cf0c$e1f5b2a0$52bffea9@zlatkovyfkpgz6 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zlatko Matić" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: "Matthew T. O'Connor" <matthew(at)zeut(dot)net>; <pgsql-general(at)postgresql(dot)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(dot)matic1(at)sb(dot)t-com(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Dugan | 2005-10-12 09:26:48 | Re: License question[VASCL:A1077160A86] |
Previous Message | Sergey Karin | 2005-10-12 08:24:41 | problem with bit(n) type |