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.

Thanks

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

Mon, 2 Oct 2000 08:42:52 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
backup and restore
"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

-------------
Hannu

Mon, 02 Oct 2000 14:45:35 +0300
Hannu Krosing <hannu@tm.ee>
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
-----------------------------------------------------------------

Tue, 3 Oct 2000 10:26:04 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
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, Pennsylvania 19026

Sun, 8 Oct 2000 00:30:29 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: backup and restore
On Sun, 08 Oct 2000, Bruce Momjian wrote:
> This will be in 7.1 as WAL (write-ahead log).

What does this exactly mean? Will this WAL be an equivalent of the logical 
log of Informix? Where will they be kept? In the database, as a file, or as 
either?
Looks pretty good. All that is needed after this is a good blob 
implementation (for text and binary data).

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

Mon, 9 Oct 2000 08:26:50 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
Re: backup and restore
"Martin A. Marques" wrote:
> 
> On Sun, 08 Oct 2000, Bruce Momjian wrote:
> > This will be in 7.1 as WAL (write-ahead log).
> 
> What does this exactly mean? Will this WAL be an equivalent of the logical
> log of Informix? Where will they be kept? In the database, as a file, or as
> either?
> Looks pretty good. All that is needed after this is a good blob
> implementation (for text and binary data).

TOAST. Coming for 7.1.

And we thought 7.0 had alot of new features relative to 6.5.....
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Mon, 09 Oct 2000 07:32:03 -0400
Lamar Owen <lamar.owen@wgcr.org>
Re: backup and restore
> "Martin A. Marques" wrote:
> > 
> > On Sun, 08 Oct 2000, Bruce Momjian wrote:
> > > This will be in 7.1 as WAL (write-ahead log).
> > 
> > What does this exactly mean? Will this WAL be an equivalent of the logical
> > log of Informix? Where will they be kept? In the database, as a file, or as
> > either?
> > Looks pretty good. All that is needed after this is a good blob
> > implementation (for text and binary data).
> 
> TOAST. Coming for 7.1.
> 
> And we thought 7.0 had alot of new features relative to 6.5.....

I think the true feature-killer release was 6.5.

-- 
  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, Pennsylvania 19026

Mon, 9 Oct 2000 14:32:36 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: backup and restore
> On Sun, 08 Oct 2000, Bruce Momjian wrote:
> > This will be in 7.1 as WAL (write-ahead log).
> 
> What does this exactly mean? Will this WAL be an equivalent of the logical 
> log of Informix? Where will they be kept? In the database, as a file, or as 
> either?
> Looks pretty good. All that is needed after this is a good blob 
> implementation (for text and binary data).

Yes, I think it will be similar to Informix logical logs.  Not sure
where they will be kept, but assume you can put it anywhere you want. 
Not sure if tape logging will be enabled.  It will be written as a file.

-- 
  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, Pennsylvania 19026

Mon, 9 Oct 2000 14:33:58 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: backup and restore
Bruce Momjian wrote:
> Lamar Owen Wrote:
> > And we thought 7.0 had alot of new features relative to 6.5.....
 
> I think the true feature-killer release was 6.5.

Well, this is true.  I skipped the whole 6.4 series for a reason :-).  I
just _knew_ 6.5 was going to be _it_... (in actuality, it's because
RPM's for 6.4 weren't available until 6.5 was nearly ready to
release...).

It was feature-shock to go from 6.3.2 to 6.5.... But the performance
difference was the real kicker, for multiuser concurrent processing.

But that changelog entry for 6.5.3->7.0 was _huge_.  And there were
significant changes to many files, not just a few -- the RPMset
differences were substantial from the building/packaging side, the side
I deal with.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Mon, 09 Oct 2000 15:24:50 -0400
Lamar Owen <lamar.owen@wgcr.org>
Re: backup and restore