On Tue, Oct 11, 2005 at 02:39:24PM -0400, Tom Lane wrote: > =?iso-8859-2?Q?Zlatko_Mati=E6?= <[EMAIL PROTECTED]> 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.
Or you can run pg_autovacuum on the server itself and allow ident authentication for unix sockets (assuming you're on unix/linux). -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
