Re: [HACKERS] Hot Backup Ability

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, Michael Richards <miker(at)scifair(dot)acadiau(dot)ca>
Cc: Duane Currie <dcurrie(at)sandman(dot)acadiau(dot)ca>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Hot Backup Ability
Date: 1999-06-30 06:09:02
Message-ID: 3.0.1.32.19990629230902.00e101d8@mail.pacifier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 09:09 PM 6/29/99 -0400, Bruce Momjian wrote:

>> Just out of curiosity, I did a DUMP on the database while running a script
>> that ran a pile of updates. When I restored the database files, it was so
>> corrupted that I couldn't even run a select. vacuum just core dumped...

>When you say DUMP, you mean pg_dump, right? Are you using 6.5?

In his first note, he was proposing a scheme that would allow either
filesystem dumps or pg_dumps, which I think a couple of respondents
missed.

So I suspect he means a filesystem dump in this case. Which of course
won't work in postgres, or in Oracle.
>
>

- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, and other goodies at
http://donb.photo.net

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Broytmann 1999-06-30 08:01:41 Re: [HACKERS] User requests now that 6.5 is out
Previous Message Adriaan Joubert 1999-06-30 05:36:28 Re: [HACKERS] User requests now that 6.5 is out