Forum OpenACS Q&A: Re: Postgres DB migration for OpenACS 5.4.1

Collapse
Posted by Dave Bauer on
Use the -O or --no-owner option to pg_dump

--no-owner
Do not output commands to set ownership of objects to match the
original database. By default, pg_dump issues ALTER OWNER or
SET SESSION AUTHORIZATION statements to set ownership of created
database objects. These statements will fail when the script is
run unless it is started by a superuser (or the same user that
owns all of the objects in the script). To make a script that
can be restored by any user, but will give that user ownership
of all the objects, specify -O.

This option is only meaningful for the plain-text format. For
the archive formats, you may specify the option when you call
pg_restore.

Collapse
Posted by Ratnakar Sagare on
I could partially restore the data from dmp file using the '-O ' option.

Now I can login with old users' credentials & able to see all the subsites.

But I could not see the data in applications like 'Photo album' etc.

Are there any patches available for upgrading postgres from 7.3.3

Thanks
Ratnakar