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@fe.up.pt

On Tue, 18 Apr 2000, Rainer Mager wrote:

> I've always done it by:
> 
> pg_dump .... [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
> 
>