From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Philip J(dot) Warner" <pjw(at)rhyme(dot)com(dot)au> |
Cc: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Jan Wieck" <JanWieck(at)Yahoo(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>, "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, "Thomas Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Subject: | Re: Big 7.1 open items |
Date: | 2000-06-22 07:17:45 |
Message-ID: | 7782.961658265@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
"Philip J. Warner" <pjw(at)rhyme(dot)com(dot)au> writes:
>> ... the thing that bothered me was this. Suppose you are trying to
>> recover a corrupted database manually, and the only information you have
>> about which table is which is a somewhat out-of-date listing of OIDs
>> versus table names.
> This worries me a little; in the Dec/RDB world it is a very long time since
> database backups were done by copying the files. There is a database
> backup/restore utility which runs while the database is on-line and makes
> sure a valid snapshot is taken. Backing up storage areas (table spapces)
> can be done separately by the same utility, and again, it records enough
> information to ensure integrity. Maybe the thing to do is write a pg_backup
> utility, which in a first pass could, presumably, be synonymous with pg_dump?
pg_dump already does the consistent-snapshot trick (it just has to run
inside a single transaction).
> Am I missing something here? Is there a problem with backing up using
> 'pg_dump | gzip'?
None, as long as your ambition extends no further than restoring your
data to where it was at your last pg_dump. I was thinking about the
all-too-common-in-the-real-world scenario where you're hoping to recover
some data more recent than your last backup from the fractured shards
of your database...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Philip J. Warner | 2000-06-22 07:50:15 | Re: Big 7.1 open items |
Previous Message | Tom Lane | 2000-06-22 07:05:00 | Re: Big 7.1 open items |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-22 07:30:19 | Re: libpq error codes |
Previous Message | Tom Lane | 2000-06-22 07:05:00 | Re: Big 7.1 open items |