Forum OpenACS Development: Missing pgbin in config.tcl

Collapse
Posted by Dave Bauer on
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.

Collapse
Posted by Jim Lynch on
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

Collapse
Posted by Victor Guerra on
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.