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

Collapse
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.

Collapse
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