How about restoring the database if it has a password?
TIA,
Raul
Raul Miguel Pinheiro de Carvalho
ISR - Instituto de Sistemas e Robotica, Porto
e-mail: rmpc@fe.up.pt
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.
>
> --Rainer
>
>
>
> > -----Original Message-----
> > From: pgsql-admin-owner@hub.org
> > [mailto:pgsql-admin-owner@hub.org]On Behalf Of Raul Carvalho
> > Sent: Tuesday, April 18, 2000 4:21 AM
> > To: Maarten Boekhold
> > Cc: pgsql-admin@postgresql.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@fe.up.pt
>
>
