From: | "Daniel Verite" <daniel(at)manitou-mail(dot)org> |
---|---|
To: | "Craig Boyd" <craig(at)mysoftforge(dot)com> |
Cc: | "Melvin Davidson" <melvin6925(at)gmail(dot)com>,"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: psql connection option: statement_timeout |
Date: | 2016-07-04 16:01:20 |
Message-ID: | ce932bde-e48a-48f5-b19b-cad2d854af94@mm |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Craig Boyd wrote:
> So to put it another way: is there a list that shows what options are
> available during the connection event or as part of the connection string?
Yes, but it belongs to the chapter on libpq. The psql docpage merely points
to it:
<quote>
-d dbname
--dbname=dbname
Specifies the name of the database to connect to. This is
equivalent to specifying dbname as the first non-option argument
on the command line.
If this parameter contains an = sign or starts with a valid URI
prefix (postgresql:// or postgres://), it is treated as a
conninfo string. See Section 31.1.1 for more information.
</quote>
In the HTML-formatted doc, this "Section 31.1.1" links to:
https://www.postgresql.org/docs/9.3/static/libpq-connect.html#LIBPQ-CONNSTRING
which has the list you want.
Besides connection options such as "connect_timout", it happens
that server config options, such as "statement_timeout", can also
be incorporated into a connection string, through the
"options" keyword and -c switch (possibly used multiple times)
For example:
$ psql -d "dbname=test connect_timeout=10 options='-c statement_timeout=1000
-c geqo=off'"
psql (9.3.13)
Type "help" for help.
test=> show statement_timeout ;
statement_timeout
-------------------
1s
(1 row)
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Boyd | 2016-07-04 16:15:58 | Re: psql connection option: statement_timeout |
Previous Message | Melvin Davidson | 2016-07-04 14:55:20 | Re: Cluster on NAS and data center. |