Postgres Pro
Downloads
Home   >   mailing lists

Re: emergency outage requiring database restart - Mailing list pgsql-hackers

From Tom Lane
Subject Re: emergency outage requiring database restart
Date
Msg-id 2077.1477097017@sss.pgh.pa.us
Whole thread Raw
In response to Re: emergency outage requiring database restart  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: emergency outage requiring database restart  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: emergency outage requiring database restart  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Jim Nasby wrote:
>> It occurs to me that it might be worth embedding the relation name in the
>> free space of the first block. Most people would never notice the missing 64
>> bytes, but it would be incredibly helpful in cases like this...

> Agreed.  The problem is how to install it without breaking pg_upgrade.

Well, that's the first problem.  The second problem is how to cope with
RENAME TABLE.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: make check-world failing for me
Next
From: Tom Lane
Date:
Subject: Re: Fun fact about autovacuum and orphan temp tables