Re: Maintenance

 that is exactly my point!

 It gives this error: (database: demo, user: demo, password: demo)

 $ echo "demo\ndemo" | pg_dump -u demo > r.dump
 Connection to database 'demo' failed.
 fe_sendauth: no password supplied

 Very strange...

Raul Miguel Pinheiro de Carvalho
ISR - Instituto de Sistemas e Robotica, Porto
e-mail: rmpc@fe.up.pt

On Mon, 17 Apr 2000, Maarten Boekhold wrote:

>
>
> 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
>