closing connection unexpectedly in postgres

Question

I am having a scenario where we close the postgres connection unexpectedly that is the jetty server which is using the connection pool. So in our scenario we are killing the jetty server issuing Kill -9 so connection pool is not closed properly , so my question is that will it going to affect the postgres database, can it cause the postgres corruption. Or all the Connections will be closed automatically and the running transactions will be rolled back without affecting the database.

If you actually kill the connection pooler, I would not call that "unexpectedly". Why do you kill it, and why with kill -KILL ? — wildplasser
– wildplasser, Commented Jul 23, 2012 at 6:22
We are killing it since we are using it in an embedded system where waiting for it to shutdown gracefully will have adverse effect on overall start time of the product. — Abhishek Parikh
– Abhishek Parikh, Commented Jul 23, 2012 at 13:32

Frank Heikens · Accepted Answer · 2012-07-23 09:34:06Z

4

Any transaction that is not committed, will cause an implicit rollback when you disconnect. This will never result in a corrupt database, a rollback never results in a corrupt database.

Using kill -9 is asking for problems, but it won't corrupt your database when you just kill the connection.

answered Jul 23, 2012 at 9:34

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Abhishek Parikh Over a year ago

But what will happen to connection at the Postgres side when my application is getting killed, will they remain open at the postgres side ?

Frank Heikens Over a year ago

No, the process will be stopped. Just do a test and see it happen.

Abhishek Parikh Over a year ago

Frank how can i Check it on the postgres side whether the Connection is still open ?

Frank Heikens Over a year ago

Check pg_stat_activity: SELECT * FROM pg_stat_activity;

Collectives™ on Stack Overflow

closing connection unexpectedly in postgres

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related