Base (postgresql): pq_driver: server closed the connection unexpectedly

asked 2018-08-31 14:38:13 +0100

rod gravatar image

Hi,

Is there a way to make Base reconnect automatically to a postgresql database when it is reused after the server close the connection?

Currently, when I re-execute a query in that case, I get the following error:

pq_driver: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. [...]

The only way I can do my query is by closing Base and opening the odb file again.

I have seen this question that seems related by for MySQL and it does not seem to work: adding the autoReconnect=true query in the URL gives an error:

Error in database URL 'sdbc:postgresql:postgresql://serverAddress/dbName?autoReconnect=true': invalid URI query parameter: "autoReconnect"

Is there a way to enable automatic reconnection for postgresql?

Thanks

edit retag flag offensive close merge delete