On Sun, Jul 3, 2016 at 6:54 PM, Craig Boyd <craig@xxxxxxxxxxxxxxx> wrote:
Hello All,
I am something of a newbie and I am trying to understand how to pass connection options using the psql client. My understanding is that it is possible to do this as part of the psql connection event.
I am on Mint and my PostgreSQL Server version = 9.3.13.
I am trying to connect to an instance on a different machine (also 9.3.13).
The following works:
psql -U username -h 192.x.x.x <enter>
But when I try to set the statement like this it fails:
psql -U username -h 192.x.x.x statement_timeout=1000
I get the following "invalid connection option" I am less concerned with actually setting this parameter than I am learning how to pass or set connection options when I log in. If it is a case where this particular option cannot be set as part of the connection string that is fine. But that leads me to ask what options can I set as part of the connection string?
I have looked here:
https://www.postgresql.org/docs/9.3/static/app-psql.html
and here:
https://www.postgresql.org/docs/9.3/static/runtime-config-client.html
I suspect I am close, but I can't seem to figure out where I am going awry.
Any thoughts?
Thanks in advance.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I suspect what you want is connect_timeout
ie: psql -U username -h 192.x.x.x connect_timeout=1000
However, if you truly want to set statement_timeout, that cannot be set at the command line. You must execute that AFTER you connect.
ie: # SET statement_timeout = 1000;
You can also place multiple commands inside a file and then execute that after you connect.
eg: # \i your_filename.sql
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.