Closing postgres connection using psql when executed from shell script

Question

How to close connection using psql when executed from shell script

Laurenz Albe · Accepted Answer · 2021-03-01 07:03:26Z

3

If you run

psql -c '/* SQL statement */'

or

psql -f script.sql

the connection will automatically be closed as soon as the command is done

answered Mar 1, 2021 at 7:03

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

2 Comments

Naveen Suryawanshi Over a year ago

Laurenz Albe, Thanks for your answer, i have scheduled job through jenkins, which hit my postgres DB in every 1 hour and in between i am getting this error "Failed to get SSH fingerprint from DB: pq: remaining connection slots are reserved for non-replication superuser connections" I doubt it could be because script does not closing the connection. according to your answer, it should close the connection, any idea why i am getting this error?

Laurenz Albe Over a year ago

There are many other connections to the database. Examine pg_stat_activity to find out where they come from.

Collectives™ on Stack Overflow

Closing postgres connection using psql when executed from shell script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related