This PR adds a new route '/db-server-version which enables the ability to retrieve the psql server version, This is needed for pint-data-manager so it can dynamically determine the correct version of pg_dump to use. Currently pint-data-manager incorrectly is set for
pg_dump = '/usr/lib/postgresql12/bin/pg_dump'
When testing upgrading the pint-server to PostgreSQL to version 14, an issue was found when running pint-data-manager due to the version mismatch between the psql server and pg_dump
Instead of just fixing this in pint-data-manager, it was suggested to make this a server function in case some other client would need access to the database server version.
This PR adds a new route '/db-server-version which enables the ability to retrieve the psql server version, This is needed for pint-data-manager so it can dynamically determine the correct version of pg_dump to use. Currently pint-data-manager incorrectly is set for
pg_dump = '/usr/lib/postgresql12/bin/pg_dump'
When testing upgrading the pint-server to PostgreSQL to version 14, an issue was found when running pint-data-manager due to the version mismatch between the psql server and pg_dump
Instead of just fixing this in pint-data-manager, it was suggested to make this a server function in case some other client would need access to the database server version.