RE: Maintenance

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(at)fe(dot)up(dot)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(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
>
>