Re: [GENERAL] pg_upgrade problem - Mailing list pgsql-hackers

From hubert depesz lubaczewski
Subject Re: [GENERAL] pg_upgrade problem
Date
Msg-id 20110831174550.GA31255@depesz.com
Whole thread Raw
In response to Re: [GENERAL] pg_upgrade problem  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [GENERAL] pg_upgrade problem
List pgsql-hackers
On Wed, Aug 31, 2011 at 01:23:05PM -0400, Bruce Momjian wrote:
> Can you get me the 9.0.X pg_class.relfrozenxid for the toast and heap
> tables involved?

Sure:

=# select oid::regclass, relfrozenxid from pg_class  where relname in ('transactions', 'pg_toast_106668498');
oid             | relfrozenxid 
 
-----------------------------+--------------pg_toast.pg_toast_106668498 |   3673553926transactions                |
3623560321
(2 rows)

Best regards,

depesz

-- 
The best thing about modern society is how easy it is to avoid contact with it.
                  http://depesz.com/
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] pg_upgrade problem
Next
From: yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi)
Date:
Subject: Re: tab stop in README