search

HEPCloud / decisionengine

HEPCloud Decision Engine framework
Apache License 2.0
6 stars 26 forks source link

Update DE client libs to pgsql-12 #547

Closed StevenCTimm closed 2 years ago

StevenCTimm commented 2 years ago

The production and dev development databases are getting upgraded to postgresql 12. We would like to change the default installation of the Decision Engine to use postgresql 12 clients as well.

StevenCTimm commented 2 years ago

To be sure, I am not quite sure how it is that the decision engine is picking which version of postgresql client libs to use. is there something we would have to set by means of PYTHONPATH to make sure the postgresql 12 bindings are used? Right now we have version 9, 11, and 12 clients all co-resident on most of the machines. The databases themselves are now all postgresql 12.

StevenCTimm commented 2 years ago

Discussion with Pat Riehecky shows that the DE binaries are using psycopg2 to talk to the postgres database. so the postgresql-libs rpm isn't actually necessary at all to run the server. It is however necessary if you are running a postgresql server on the same machine for integration testing, or if you want to have a psql client available on the machine to check the database with.

So there is nothing that has to be done by the developers on this issue. Closing it.