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

Figure 1Figure 1

Figure 1

Figure 2Figure 2

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.
Figure 3Figure 3

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.
Figure 4Figure 4

Figure 4

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


Did this page help you?