Re: backup and restore

On Mon, 02 Oct 2000, Hannu Krosing wrote:
> "Martin A. Marques" wrote:
> > Hi,
> >
> > I would like to know if postgres comes with some kind of backup
> > application? I mean something that would do database backup and restore,
> > something like informix's ontape and logical logs.
>>
> Take a look at pg_dump and pg_dumpall

Well, that would only be part og what I'm looking for. The thing I like about 
informix is that I can make a Level 0 backup of all the data (equal to the 
pg_dumpall), and then leave the logical logs downloading continuosly, so that 
if in one moment the system breaks, I restore the Level 0 backup and then 
apply the logical logs, which are the small changes that have been done to 
the database in each transaction, administration, etc.

Could this be added? I am willing to help with the coding.

Saludos... :-)

-- 
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Mart�n Marqu�s            email:     martin@math.unl.edu.ar
Santa Fe - Argentina        http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------