Connection error "PostgreSQL: 08P01: unsupported startup parameter: ssl_renegotiation_limit"

[lawrencecmp]

I was trying to connect to a PostgreSQL db from PBI and received the following error:

"PostgreSQL: 08P01: unsupported startup parameter: ssl_renegotiation_limit"

There are limited threads talking about this error and the suggested solutions do not work to me so i post a new one here and hope that someone can help me out. Thanks a lot in advance.

[v-yingjl · Accepted solution]

Hi @lawrencecmp ,

As far as I know, this parameter had been deprecated in 9.4 version of PostgresSQL DB.

You can try different ways to connect to PostgresSQL DB, refer this article:

PostgreSQL To Power BI: 3 Best Ways To Connect 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@lawrencecmp , refer if those two can help

https://community.powerbi.com/t5/Issues/PostgreSQL-error-unsupported-startup-parameter/idi-p/2032268

https://github.com/pgbouncer/pgbouncer/issues/472