Received: from ncc1701.cistron.net (ncc1701.cistron.net [195.64.68.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3497L890969 for ; Wed, 4 Apr 2001 05:07:22 -0400 (EDT) (envelope-from news@uucp.cistron.nl) Received: from news by ncc1701.cistron.net with local (Exim 3.20 #1 (Debian)) id 14kjG3-0006lz-00 for ; Wed, 04 Apr 2001 11:07:19 +0200 From: jdassen@cistron.nl (J.H.M. Dassen (Ray)) Subject: Re: pg_dumpall and password access Date: Wed, 4 Apr 2001 09:07:18 +0000 (UTC) Organization: Cistron Internet Services B.V. Lines: 16 Message-ID: References: <29370.986340578@sss.pgh.pa.us> X-Trace: ncc1701.cistron.net 986375238 24181 195.64.65.236 (4 Apr 2001 09:07:18 GMT) X-Complaints-To: abuse@cistron.nl To: pgsql-sql@postgresql.org Errors-To: news@news.cistron.nl X-Archive-Number: 200104/32 X-Sequence-Number: 2372 Tom Lane wrote: >pg_dumpall doesn't work very well with password authentication (and >even if it did, storing the password in a cron script doesn't seem >like a good idea to me). > >As long as the dumper will run on the same machine as the database >server, consider using IDENT authorization instead. Another solution is to use the patched pg_dumpall at http://bugs.debian.org/87035 . Ray -- The Internet interprets attempts at proprietary control as damage and routes around it. Eric S. Raymond