Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-25 Thread Jeff Ross
On 5/25/14, 11:44 AM, Andres Freund wrote: Hi, On 2014-05-23 08:23:57 -0600, Jeff Ross wrote: UDB=# \x Expanded display is on. UDB=# SELECT attrelid::regclass, attname, attnum, attlen, * FROM pg_attribute WHERE attrelid = 'masterairportlist'::regclass ORDER BY attnum ASC; UDB=# [ RECORD 1

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-23 Thread Jeff Ross
On 5/23/14, 7:36 AM, Andres Freund wrote: Any chance you could, *before* you create the toast table, do a: SELECT attrelid::regclass, attname, attnum, attlen, * FROM pg_attribute WHERE attrelid = 'a'::regclass ORDER BY attnum ASC; Where 'a' is replaced by the affected table? Greetings,

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-23 Thread Jeff Ross
On 5/23/14, 7:21 AM, Bruce Momjian wrote: On Thu, May 22, 2014 at 09:20:38AM -0600, Jeff Ross wrote: I just tested ALTER TABLE in 8.4 and it does create a toast table for this case in 9.4: CREATE TABLE test (x CHAR(10)); ALTER TABLE test ALTER COLUMN x TYPE CHAR(8000); I

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-22 Thread Jeff Ross
On 5/21/14, 2:37 PM, Bruce Momjian wrote: On Wed, May 21, 2014 at 04:23:34PM -0400, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: On Wed, May 21, 2014 at 10:56:59AM -0600, Jeff Ross wrote: Yes, using 9.3's pg_dump of 8.4 and applying it to both an 8.4 and a 9.3 cluster

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-21 Thread Jeff Ross
On 5/21/14, 9:13 AM, Bruce Momjian wrote: On Wed, May 21, 2014 at 09:11:05AM -0600, Jeff Ross wrote: -- For binary upgrade, set heap's relfrozenxid UPDATE pg_catalog.pg_class SET relfrozenxid = '1944' WHERE oid = 'contact_email'::pg_catalog.regclass; -- For binary upgrade, set toast's

[HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-20 Thread Jeff Ross
and it restored with psql to 9.3.4 with no issues but the overall migration will really be too big to go this route. Any ideas? Thanks! Jeff Ross -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 - 9.3

2014-05-20 Thread Jeff Ross
On 5/20/14, 2:22 PM, Bruce Momjian wrote: On Tue, May 20, 2014 at 12:59:31PM -0600, Jeff Ross wrote: Removing support functions from new cluster ok Copying user relation files /var/lib/postgresql/8.4/main/base/4275487/4278965 Mismatch of relation OID in database FNBooking