Forum OpenACS Q&A: Re: Postgres

5: Re: Postgres (response to 1)

Posted by Tilmann Singer on 03/14/04 07:19 PM

I'm running an oacs-5-0 site on pg 7.4.1 (debian unstable) without any problems but one: the /admin/groups/one admin page is broken, it fails with

ERROR: variable not found in subplan target lists

but I guess that is fixed on recent pg versions, judging from this changelog entry: http://www.postgresql.com/news/173.html

So if you go to pg 7.4 make sure you install the latest released version.

7: Re: Postgres (response to 5)

Posted by Tilmann Singer on 03/14/04 07:40 PM

For restoring the truncated identifiers see bin/pg_7.2to7.3_upgrade_helper.pl in your openacs checkout.

Also note that when restoring a dump into a 7.4 database it is not necessary anymore to manually run acs-kernel/sql/postgresql/postgresql.sql before the restore, on the contrary the restore will fail if you do this before. At least that was my experience - could anyone confirm this behaviour? If yes then we should get this in the docs.

8: Re: Postgres (response to 7)

Posted by Richard Hamilton on 03/17/04 11:56 AM

Don, Tilmann,

Thanks very much for taking the time to reply.

I will do exactly as you suggest. The only bit I am unclear on is where you said:

"You might want to run your dump (just scheme, not data) into a virgin PG 7.2 instance to look for such
truncations so you can fix them in your own code as well as "our" code when you restore into 7.3 or 7.4 (only functions, index name truncation and the like are
harmless)."

Do I need to do this with PG 7.2 before I try running a restore into 7.4?

Regards
Richard