Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

You can create connections to one or more 

D s conntype
typepostgres
 databases  database from 
D s product
rtrue
. For more information on 
D s conntype
typepostgres
, see https://www.postgresql.org/.

Supported Versions: 9.3.10

...

PropertyDescription
Host
Enter your fully qualified hostname. Example:

 

Code Block
my.postgres.server


PortSet this value to 5432.
Connect String Options

Insert any additional connection parameters, if needed. See below.

Enable SSL

Select the checkbox to enable SSL connections to the database.

Info

NOTE: Additional configuration may be required in the database server. For more information, please consult the documentation that was provided with the distribution.


DatabaseEnter the name of the database on the server to which to connect.
User NameUsername to use to connect to the database.
PasswordPassword associated with the above username.
Test ConnectionAfter you have defined the connection credentials type, credentials, and connection string, you can validate those credentials.
Default Column Data Type Inference

Set to disabled to prevent the platform from applying its own type inference to each column on import. The default value is enabled.

Connection NameDisplay name of the connection
Connection DescriptionDescription of the connection, which appears in the application.

...

D s api refdoclink
#operation/createConnection

Troubleshooting

Error messageDescription
Class 08 Connection Exception

Connection failure: the web client or

D s node
is unable to establish a connection.

Class 28 Invalid Authorization Specification

Typically, this error occurs when an invalid password has been submitted.

Tip

Tip: Use the Test Connection button to validate your credentials.


For more information on error messages for this connection type, see https://www.postgresql.org/docs/9.3/errcodes-appendix.html.

...