search

atris / JDBC_FDW

FDW that wraps JDBC for PostgreSQL.It can be used to connect and fetch data from any data source that supports JDBC
Other
66 stars 38 forks source link

while reloading postgres java hangs #18

Closed MelanieGault closed 3 years ago

MelanieGault commented 8 years ago

Hi,

I use your module since a long time and everything works fine. Tanks a lot !

But recently I have a new app which use JDBC FDW very frequently. At each reload of postgres (SIGHUP) the postmaster process forward SIGHUP to every child. And the JAVA one considers this signal as a abnormal terminaison, and stops immediatly. As a consequence the postmaster goes into recovery mode because of a crash of one of his child.

I see that -Xrs option passed to the JVM will change that behaviour, but I dont see anything in possible options.

How do you manage that case ? thanks

Melanie

atris commented 8 years ago

Hi!

I can add the case as an option to the JVM (See where JVM options are passed to JVM). Please feel free to add a patch for it though!

MelanieGault commented 8 years ago

Hi,

OK thanks for your answer. I'm not good enough in C language to do it by myself.