| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
| Cc: | George Johnson <gjohnson(at)jdsc(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: backend corruption |
| Date: | 2001-01-07 00:09:35 |
| Message-ID: | 5693.978826175@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Brett W. McCoy" <bmccoy(at)chapelperilous(dot)net> writes:
> On Sat, 6 Jan 2001, George Johnson wrote:
>> So basically, I've wiped all my databases, it looks like, and no, there is
>> no directory/structure which atomically can be called "your database", other
>> than the ENTIRE data/base directory.
> Sure there is -- under my $PGHOME/data/base, each separate database on my
> system is a sub-directory, which contain the system dictionaries, tables,
> indexes, etc.
Yeah, but those files are only half the truth. The other half lives in
pg_log and the installation-wide tables (pg_database, etc). George is
correct: you cannot recover using only the contents of $PGDATA/base/foo.
You really need all of $PGDATA.
I think that under 7.1, pg_log is not so critical anymore, but I'm not
sure. Vadim, any comment?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brett W. McCoy | 2001-01-07 00:18:05 | Re: backend corruption |
| Previous Message | Brett W. McCoy | 2001-01-06 23:32:25 | Re: backend corruption |