PostgreSQL

In this doc, we will cover how to setup a Connection to a Postgres database.

Prerequisites

  • Access credentials
  • Database Name

πŸ“˜

If your Postgres server is in a private subnet or VPC and not accessible from the public internet, you will need to set up connectivity to it from Ascend. Your Ascend representative can help with this process and the common options are documented under Network Connectivity

Create new PostgreSQL connection

2408

Figure 1

1106

Figure 2

  • Connection Name (required): The name to identify this connection with, such as Postgres Connection.
  • Host (required): Hostname or IP address of the PostgreSQL server.
  • Port (optional): Port number of the PostgreSQL server for the clients to connect.
  • Database Name (required): The database name.
  • Choose Credentials (required): Choose from existing credentials or create new credential for connecting to PostgreSQL server if 'Required Credentials' checkbox is selected. You can also choose to edit a credential with the EDIT button next to the existing credential.
486

Figure 3

  • Credential Name (required): The name to identify this credential with, such as postgres-cred.
  • User (required): Postgres username to connect with.
  • Password (required): Postgres password to connect with.
994

Figure 4

Use TEST CONNECTION button check if the connection is a SUCCESS and then click CREATE AND USE CONNECTION. (Figure 4)