How about restoring the database if it has a password?
Raul Miguel Pinheiro de Carvalho
ISR - Instituto de Sistemas e Robotica, Porto
On Tue, 18 Apr 2000, Rainer Mager wrote:
> I've always done it by:
> pg_dump .... [enter]
> <blindly type username [enter] password [enter]>
> This works for me with the note that the dump file now has my username and
> password at the top of it.
> > -----Original Message-----
> > From: pgsql-admin-owner(at)hub(dot)org
> > [mailto:pgsql-admin-owner(at)hub(dot)org]On Behalf Of Raul Carvalho
> > Sent: Tuesday, April 18, 2000 4:21 AM
> > To: Maarten Boekhold
> > Cc: pgsql-admin(at)postgresql(dot)org
> > Subject: Re: [ADMIN] Maintenance
> > 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
In response to
pgsql-admin by date
|Next:||From: Margarita Barvinok||Date: 2000-04-18 15:55:06|
|Subject: Re: DEFAULT now() ?|
|Previous:||From: ty||Date: 2000-04-18 10:36:53|
|Subject: DEFAULT now() ?|