From: | Craig Boyd <craig(at)mysoftforge(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | psql connection option: statement_timeout |
Date: | 2016-07-03 22:54:42 |
Message-ID: | 577997B2.3020003@mysoftforge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2016-07-03 23:15:41 | Re: psql connection option: statement_timeout |
Previous Message | Patrick B | 2016-07-03 22:17:55 | Re: Unable to recovery due missing wal_file |