Re: AW: backup and restore

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, "'Martin A(dot) Marques'" <martin(at)math(dot)unl(dot)edu(dot)ar>, Hannu Krosing <hannu(at)tm(dot)ee>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: AW: backup and restore
Date: 2000-10-12 15:31:37
Message-ID: 3.0.5.32.20001013013137.00c42920@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 16:21 12/10/00 +0200, Zeugswetter Andreas SB wrote:
>>
>> Could this be added? I am willing to help with the coding.
>
>This is what Version 7.1 WAL is all about.
>There might be some help wanted in one of the possible backup methods:
> 1. a pg_dumpall restore, and a subsequent restore of logs
> 2. a restore of a "physical backup of db files" + subsequent restore of logs
>
>I think Vadim has the 1st way in his works.

My guess is that there are some issues to resolve: I presume the WAL uses
OID to identify rows, which will mean that BLOB restoration won't work
because it changes the OID of the BLOB. Also, pg_dump will restore row OIDs
for table data, but not the OID for such things as sequences. Guessing
again, I'd say that sequence updates in the WAL will also be OID based.

It's definitely true that the WAL is an essential first step to proper
backup, but there's probably the need to write a backup utility as well.
Unless of course Vadim has done that as well...

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-10-12 15:43:54 Re: AW: Proposal: TRUNCATE TABLE table RESTRICT
Previous Message Bruce Momjian 2000-10-12 15:29:50 Re: postgresql 7.1