From: | Maarten Boekhold <maarten(dot)boekhold(at)tibcofinance(dot)com> |
---|---|
To: | Raul Carvalho <rmpc(at)fe(dot)up(dot)pt> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Maintenance |
Date: | 2000-04-17 11:29:21 |
Message-ID: | 38FAF591.EC748AD1@tibcofinance.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)boekhold(at)tibcofinance(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Loïc TREGOUËT | 2000-04-17 16:37:40 | This Object side of postgresql |
Previous Message | Raul Carvalho | 2000-04-17 11:25:53 | Maintenance |