X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4C632D1D8AE for ; Tue, 13 Jan 2004 19:55:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 26323-02 for ; Tue, 13 Jan 2004 15:54:35 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id 28DDFD1DA63 for ; Tue, 13 Jan 2004 15:54:34 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HRG00H011P8MF@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Wed, 14 Jan 2004 01:24:34 +0530 (IST) Received: from sancharnet.in ([61.0.95.101]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HRG00J9J1YIS3@ndl1mr1-a-fixed.sancharnet.in>; Wed, 14 Jan 2004 01:24:34 +0530 (IST) Date: Wed, 14 Jan 2004 01:30:40 +0530 From: Sai Hertz And Control Systems Subject: Re: psql Automatic login In Bash Script In-reply-to: <200401132047.28432.peter.eisentraut@credativ.de> To: Peter Eisentraut Cc: aspire420@hotpop.com, pgsql-admin@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <40044E68.9020802@sancharnet.in> Organization: Sai Hertz And Control Systems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 References: <40044B5D.9040909@sancharnet.in> <200401132047.28432.peter.eisentraut@credativ.de> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/108 X-Sequence-Number: 11971 Dear Peter Eisentraut >>and my database migration would go smothly >> >> > >That would be a security hole because then other users can read the >password using 'ps'. > >>Also would not like to set ~/.pgpass >>Why not? That's what it's for. >> >> Agreed and now we decided to use it but will ~/.pgpass work for pg_dump pg_restore Regards, Vishal Kashyap