Re: user privilages for executing pg_autovacuum?

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" 
To: "Zlatko Matić" 
Cc: 
Sent: Tuesday, October 11, 2005 4:00 PM
Subject: Re: [GENERAL] 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