Forum OpenACS Q&A: Re: Upgrade PG 7.3.4 to 7.4.1


	The Toolkit for Online Communities 15889 Community Members, 0 members online, 1660 visitors today			Log In	Register

Forum OpenACS Q&A: Re: Upgrade PG 7.3.4 to 7.4.1

OpenACS Home : Forums : OpenACS Q&A : Re: Upgrade PG 7.3.4 to 7.4.1 : One Message

Back to OpenACS Q&A

8: Re: Upgrade PG 7.3.4 to 7.4.1 (response to 7)

Posted by Tilmann Singer on 03/11/04 03:26 PM

I did a restore of a pg 7.4.1 dump on a pg 7.4.1 database recently and saw the same error. It turned out that it works when omitting the manual loading of postgresql.sql before restoring the dump, maybe the same applies to upgrades.

10: Re: Upgrade PG 7.3.4 to 7.4.1 (response to 8)

Posted by Malte Sussdorff on 03/11/04 05:46 PM

Tilmann, you are hereby declared saviour of the day :). It works.

Now someone has to make a note on that in the documentation....

12: Re: Upgrade PG 7.3.4 to 7.4.1 (response to 10)

Posted by Mark McI on 09/17/04 03:43 AM

Hello Malte,

I am experiencing this EXACT problem. I see that Tillman suggested omitting the manual loading of postgresql.sql. Can you briefly explain what that is?

I am dumping with pg_dump and restoring with the following command:
psql -e dbname < db_dump.sql

Any help you can provide will be MUCH appreciated as I'm inexperienced with postgres and totally stumped.

13: Re: Upgrade PG 7.3.4 to 7.4.1 (response to 12)

Posted by Rocael Hernández Rizzardini on 09/17/04 05:49 AM

do
psql -f packages/acs-kernel/sql/postgresql/postgresql.sql dbname

(that should do the trick)

when I restore a dump, usually do something like:
psql -f dump.file dbname

Back to OpenACS Q&A