pycharm and postgres: ERROR: Unsupported startup parameter: extra_float_digits

Question

Having issue to connect to PostgreSQL 9.0 database from PyCharm. I already tried adding older jdbc driver manually but still getting the same error: "ERROR: Unsupported startup parameter: extra_float_digits".

Answer 1

I had this error using the PostgreSQL JDBC driver connecting to PgBouncer. The fix was to add the following to pgbouncer.ini (which was already in the file but commented out):

ignore_startup_parameters = extra_float_digits

(similar to the previous answer but different config file)

Answer 2

The "fix" is to add this to the config.ini under the [pgbouncer] section:

ignore_startup_parameters = extra_float_digits

Details here: https://github.com/Athou/commafeed/issues/559