Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: user privilages for executing pg_autovacuum?
Date
Msg-id 17692.1129055964@sss.pgh.pa.us
Whole thread Raw
In response to Re: user privilages for executing pg_autovacuum?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
Responses Re: user privilages for executing pg_autovacuum?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
Tree view 
=?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

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: PostgreSQL's bug tracker
Next
From: Tony Caduto
Date:
Subject: Re: Considering an upgrade...