Re: more corruption - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: more corruption
Date
Msg-id 200007101857.OAA00347@candle.pha.pa.us
Whole thread Raw
In response to Re: more corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: more corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Yes, I had forgotten.  The new table file names will make pg_upgrade
> > useless in the future.
> 
> Hmm ... that's an implication I hadn't thought about.  I wonder how much
> work it would be to get pg_upgrade to rename table files.  Be a shame to
> throw pg_upgrade away after all the sweat we put into making it work ;-)

Seems impossible.  The physical file names are not dumped by pg_dump, so
there is really no way to re-assocate the files with the table names. 
Looks like a lost cause.

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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: [GENERAL] PostgreSQL vs. MySQL
Next
From: Bruce Momjian
Date:
Subject: Re: more corruption