Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL Connection String command line options

In the first format, each parameter setting is in the form keyword = value. Spaces around the equal sign are optional. To write an empty value, or a value containing spaces, surround it with single quotes, e.g., keyword = 'a value'. Single quotes and backslashes within the value must be escaped with a backslash, i.e., \' and \\.
host=localhost port=5432 dbname=mydb connect_timeout=10
The recognized parameter key words are listed in below link

Connection URIs

The general form for a connection URI is:
The URI scheme designator can be either postgresql:// or postgres://. Each of the URI parts is optional. The following examples illustrate valid URI syntax uses:
Components of the hierarchical part of the URI can also be given as parameters. For example:
Percent-encoding may be used to include symbols with special meaning in any of the URI parts.
Any connection parameters not corresponding to key words listed in  are ignored and a warning message about them is sent to stderr.
For improved compatibility with JDBC connection URIs, instances of parameter ssl=true are translated into sslmode=require.
The host part may be either host name or an IP address. To specify an IPv6 host address, enclose it in square brackets:
The host component is interpreted as described for the parameter host. In particular, a Unix-domain socket connection is chosen if the host part is either empty or starts with a slash, otherwise a TCP/IP connection is initiated. Note, however, that the slash is a reserved character in the hierarchical part of the URI. So, to specify a non-standard Unix-domain socket directory, either omit the host specification in the URI and specify the host as a parameter, or percent-encode the path in the host component of the URI:


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

PostgreSQL Monitoring Tools

PostgreSQL pgBadger