Home / server / Questions / 1068413
In Process
Justin
Asked: 2021-07-02 10:31:39 +0800 CST

Set connection timeout using psql command line interface

  • 772

Is there a way to set the connection timeout using psql cli? How can I set a connection timeout to something low like 3 seconds using the following:

PGPASSWORD=passwordhere psql -h 10.0.0.144 -U myuser -c "select 1" -d mydatabase

As far as I can tell, psql does not support a connection timeout parameter. In the example above 10.0.0.144 is invalid and this command hangs for a long time. I need the command to fail fast if the host is incorrect.

postgresql psql

1 Answers

  1. Assuming psql uses libpq, I think the environment variable PGCONNECT_TIMEOUT might work for setting connect timeout.

    You can check the libpq chapter of the official documentation for more details (do not forget to select the version you are using):

    https://www.postgresql.org/docs/current/libpq-envars.html

    • 5