Skip site navigation (1) Skip section navigation (2)

RE: Maintenance

From: Raul Carvalho <rmpc(at)fe(dot)up(dot)pt>
To: Rainer Mager <rmager(at)vgkk(dot)co(dot)jp>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: RE: Maintenance
Date: 2000-04-18 10:58:11
Message-ID: Pine.OSF.3.96.1000418115737.28762A-100000@saga.fe.up.pt (view raw or flat)
Thread:
Lists: pgsql-admin
 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
> 
> 


In response to

pgsql-admin by date

Next:From: Margarita BarvinokDate: 2000-04-18 15:55:06
Subject: Re: DEFAULT now() ?
Previous:From: tyDate: 2000-04-18 10:36:53
Subject: DEFAULT now() ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group