Skip to content

TimescaleDB credentials#

You can use these credentials to authenticate the following nodes:

Prerequisites#

An available instance of TimescaleDB.

Supported authentication methods#

  • Database connection

Refer to Timescale's documentation for more information about the service.

Using database connection#

To configure this credential, you'll need:

  • The Host: The fully qualified server name or IP address of your TimescaleDB server.
  • The Database: The name of the database to connect to.
  • A User: The user name you want to log in with.
  • A Password: Enter the password for the database user you are connecting to.
  • Ignore SSL Issues: If turned on, n8n will connect even if SSL certificate validation fails and you won't see the SSL selector.
  • SSL: This setting controls the ssl-mode connection string for the connection. Options include:
    • Allow: Sets the ssl-mode parameter to allow. First try a non-SSL connection; if that fails, try an SSL connection.
    • Disable: Sets the ssl-mode parameter to disable. Only try a non-SSL connection.
    • Require: Sets the ssl-mode parameter to require, which is the default for TimescaleDB connection strings. Only try an SSL connection. If a root CA file is present, verify that a trusted certificate authority (CA) issued the server certificate.
    • Verify: Sets the ssl-mode parameter to verify-ca. Only try an SSL connection and verify that a trusted certificate authority (CA) issued the server certificate.
    • Verify-Full: Sets the ssl-mode parameter to verify-full. Only try an SSL connection, verify that a trusted certificate authority (CA) issued the server certificate and that the requested server host name matches that in the certificate.
  • Port: The port number of the TimescaleDB server.

Refer to Timescale's connection settings documentation for more information about the non-SSL fields. Refer to Connect with a stricter SSL for more information about the SSL options.