Forum OpenACS Development: Re: OpenACS 5.8.1 upgrade for PostgreSQL 9.4.0

Collapse
6: Re: OpenACS 5.8.1 upgrade for PostgreSQL 9.4.0 (response to 5)
Posted by Gustaf Neumann on 01/19/15 09:00 AM
Very strange. The upgrade scripts are loaded via the configured version of psql.

Can it be that the openacs-config file of that installation has a very old or broken pgbin configured? See in section "ns/db/driver/postgres" parameter "pgbin".

Collapse
7: Re: OpenACS 5.8.1 upgrade for PostgreSQL 9.4.0 (response to 6)
Posted by Dave Bauer on 01/20/15 01:34 AM
Thanks Gustaf! I should have read the sample config file more closely. I didn't realize the pgbin parameter existed. I was just lucky before.

I am not sure why setting the PATH in the nsd-postgres startup script did not allow Naviserver to use the correct psql but setting the parameter is more reliable, I think.

Collapse
8: Re: OpenACS 5.8.1 upgrade for PostgreSQL 9.4.0 (response to 7)
Posted by Gustaf Neumann on 01/20/15 02:20 PM
The configuration parameter pgbin is a pretty long time in OpenACS: it was added between the releases of oacs-4-6 and oacs-5 in 2003 by Andrew Piskorski. I should have read your first posting more carefully, which contained already all necessary hints.