Forum OpenACS Development: Missing pgbin in config.tcl

Posted by Dave Bauer on 08/09/12 03:40 PM

Hi,

db_get_pgbin procedure looks for an ns/db/driver/${driver} pgbin setting in the config.tcl file.

This section doesn't exist in the latest sample config files.

Due to this, installing on a system with more than one version of PostgreSQL installed can be a problem as it'll use whatever is the default path to psql which might be the wrong version.

I suppose we can use a startup script that sets the correct PostgreSQL install as a priority in the environment but I was wondering if there is a sensible way to fix this in the config file.

2: Re: Missing pgbin in config.tcl (response to 1)

Posted by Jim Lynch on 08/10/12 03:08 PM

Can we just put the section back in to the "sample" config.tcl?

I'm definitely one person who might have more than one pg instance on a host.

-Jim

3: Re: Missing pgbin in config.tcl (response to 1)

Posted by Victor Guerra on 08/20/12 02:15 PM

I am not sure if the section ever existed in the config.tcl file. I quickly browsed the history but did not find when it was added or deleted. Anyhow, I guess we should add it.

Not only one could run into problems b/c of having several versions of the pg client but in case psql is not found in the default path one can not even run upgrade|creation scripts.