Forum OpenACS Q&A: Response to pg_dump 7.1RC2 problems

Collapse
Posted by Roberto Mello on
Thanks for testing Pascal. After the midterm I have tomorrow, I am going to upgrade a vanilla 3.2.4 install to 3.2.5 and see what is wrong allong with your post here.

Now, you're running PG 7.0, so there are some issues related to creation of functions in dump files that you have to be aware of. Last time I needed to move my dumped OpenACS db, I had to load www/doc/sql/postgres.sql BEFORE loading in my dumped db.

And yes, you should always test it on a dump before applying to your production db. More news on this tomorrow.