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@xxxxxxxx>
To: "Zlatko Matić" <zlatko.matic1@xxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, October 11, 2005 4:00 PM
Subject: Re: 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
