Forum OpenACS Q&A: Re: PG 7.2->7.3 upgrade gotcha?

Collapse
Posted by Jun Yamog on
Hi,

I created a simple script to read the dump file. And functions that has 31 chars, I try to look for the function name on the oacs dir. Then substitute it.

You can get the script here:

https://openacs.org/storage/file?file_id=117145

This only cover functions. I did saw 2 views that needs un-truncating too, they are:

ad_template_sample_users_sequence
acs_privilege_descendant_map_view
After restoration, views that make use of the truncated functions. Must be rebuilt. It varies from 0 to a couple, will depend on what packages are installed. So log your restoration process to a log file.

Hope this helps someone.

Also since I just go over the table name, view name and function name. Did I miss anything major? This are the things that are created during restore:

CREATE CONSTRAINT
CREATE FUNCTION
CREATE INDEX
CREATE RULE
CREATE SEQUENCE
CREATE TABLE
CREATE TRIGGER
CREATE TRUSTED
CREATE UNIQUE
CREATE VIEW