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
> -----------------------------------------------------------------
> Martn Marqus email: martin(at)math(dot)unl(dot)edu(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026