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@xxxxxxxxxxxxx>
To: "Zlatko Matić" <zlatko.matic1@xxxxxxxxxxx>
Cc: "Matthew T. O'Connor" <matthew@xxxxxxxx>; <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, October 11, 2005 8:39 PM
Subject: Re: user privilages for executing pg_autovacuum?
=?iso-8859-2?Q?Zlatko_Mati=E6?= <zlatko.matic1@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
