Re: backup and restore

This will be in 7.1 as WAL (write-ahead log).

> 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
> -----------------------------------------------------------------
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026