From: | Raul Carvalho <rmpc(at)fe(dot)up(dot)pt> |
---|---|
To: | Maarten Boekhold <maarten(dot)boekhold(at)tibcofinance(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Maintenance |
Date: | 2000-04-17 19:20:53 |
Message-ID: | Pine.OSF.3.96.1000417201942.30205A-100000@saga.fe.up.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Oh, I also tryed some of these:
(echo "user\n"; echo "password\n") | pg_dump.....
echo "user\npassword\n" | .....
It doesn't seem to work, though...
Raul Miguel Pinheiro de Carvalho
ISR - Instituto de Sistemas e Robotica, Porto
e-mail: rmpc(at)fe(dot)up(dot)pt
On Mon, 17 Apr 2000, Raul Carvalho wrote:
>
> 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(at)fe(dot)up(dot)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(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 | Rainer Mager | 2000-04-18 00:48:03 | RE: Maintenance |
Previous Message | Raul Carvalho | 2000-04-17 17:39:45 | Re: Maintenance |