Received: from camino.pa.tibcofinance.com ([216.101.119.58]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA75865 for ; Mon, 17 Apr 2000 07:39:04 -0400 (EDT) (envelope-from maarten.boekhold@tibcofinance.com) Received: from tekbspa.tibcofinance.com (tekbspa.tibcofinance.com [160.101.12.31]) by camino.pa.tibcofinance.com (8.9.3/8.9.3) with ESMTP id EAA20566; Mon, 17 Apr 2000 04:30:37 -0700 (PDT) Received: from tibcofinance.com ([160.101.164.50]) by tekbspa.tibcofinance.com (8.9.3/Pro-8.9.3) with ESMTP id EAA01664; Mon, 17 Apr 2000 04:32:48 -0700 (PDT) Message-ID: <38FAF591.EC748AD1@tibcofinance.com> Date: Mon, 17 Apr 2000 13:29:21 +0200 From: Maarten Boekhold Organization: TIBCO Finance Technology Inc. X-Mailer: Mozilla 4.7 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Raul Carvalho CC: pgsql-admin@postgresql.org Subject: Re: Maintenance References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/59 Raul Carvalho wrote: > > Hello all, > > I am having a problem regarding maintenance of my databases. I have four > small db's and clients must use password autentication. > > The problem is that when I try to pg_dump any of them, I don't know how > can I pass username and password. Shouldn't there be a command line option > to do this? Environment variables are very unconvenient... echo "username\npassword" | pg_dump -u .... > The same problem regarding restoring the database. "cat xpto.dump | psql > -e dbname" also asks for passwd... echo "username\npassword" | psql -u -f xpto.dump .... btw. if executing this from a script I find environment variables more convenient. Maarten -- Maarten Boekhold, maarten.boekhold@tibcofinance.com TIBCO Finance Technology Inc. "Sevilla" Building Entrada 308 1096 ED Amsterdam, The Netherlands tel: +31 20 6601000 (direct: +31 20 6601066) fax: +31 20 6601005 http://www.tibcofinance.com