Forum OpenACS Q&A: Re: 4.6 upgrade questions

Collapse
9: Re: 4.6 upgrade questions (response to 1)
Posted by Dave Bauer on
Kevin the oid error message you are receiving is due to
using the -o switch to pg_dump. Do not use that switch.

Also if you read here, you will need to recreate the party_approved_member_map view.

https://openacs.org/doc/misc/openacs-pg-migration.txt

Collapse
10: Re: 4.6 upgrade questions (response to 9)
Posted by Kevin Murphy on
Dave,

Thanks for replying, but I get the error regardless of whether I use pg_dump's -o switch or not (I just tried it).

Also, Roberto's migration instructions specifically indicate the -o switch.

I have been using his instructions, so I know about the views.  His instructions have some gaps in them; they are definitely more for experts than not, so I am wondering if I am missing something.

(This may be neither here nor there, but if I dump with -o and then import back into PG 7.1, I do not get the oid problem.)

I am being careful about using 7.1 or 7.2 binaries and environment variables as appropriate.

-Kevin

P.S.  Here's a script showing me redoing the whole procedure NOT using the -o switch:

Script started on Wed Jan 22 14:10:03 2003
nsadmin@linux:/web/med_dev> pg_dump -V
pg_dump (PostgreSQL) 7.1.3
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT to see the usage and distribution terms.
nsadmin@linux:/web/med_dev> pg_dump media >media-7.1.dmp
nsadmin@linux:/web/med_dev> . ~/pg723.sh
nsadmin@linux:/web/med_dev> which dropdb
/usr/local/pgsql-7.2.3/bin/dropdb
nsadmin@linux:/web/med_dev> dropdb med_dev
DROP DATABASE
nsadmin@linux:/web/med_dev> createdb -T template0 med_dev
CREATE DATABASE
nsadmin@linux:/web/med_dev> createdlang plpgsql med_dev
nsadmin@linux:/web/med_dev> psql -f postgresql-7.1.sql med_dev

(a bunch of CREATE's, etc, -- no errors)

nsadmin@linux:/web/med_dev> psql -f media-7.1.dmp med_dev 2>errors-no-o.log >/dev/null
nsadmin@linux:/web/med_dev> grep ERROR errors-no-o.log | grep -v "already exists"
psql:media-7.1.dmp:740: ERROR:  No such attribute or function 'oid'
psql:media-7.1.dmp:4678: ERROR:  parser: parse error at or near "SELECT"
psql:media-7.1.dmp:4686: ERROR:  parser: parse error at or near "SELECT"
psql:media-7.1.dmp:21324: ERROR:  Relation "party_approved_member_map" does not exist