Skip to main content

Postgres

Humalect provides several databases that you can integrate and bring your data to the platform with minimal permissions from Humalect's side, in this article, we will be focusing on Postgres.

Postgres is a free and open-source relational database management system that is used for managing large amounts of structured data. It offers robust support for SQL, as well as several advanced features, including multi-version concurrency control, point-in-time recovery, and native replication.

For more information, see Postgres Docs.

Prerequisites

  1. Have a connected cloud provider
  2. Have a connected source code provider
  3. Have a cluster

Create a Postgres Datasource

Let's create a Datasource with Postgres version 14.11.0

Step 1: Go to the DataSources Tab from the UI (or click here to get redirected) and click on + Create New Datasource. Step 2: Enter the following details:

FieldDesc
Namename of your Datasource
Select Clustercluster name where you want your Datasource to be created
Select DataSourcechoose database/cache of your choice
Select Versionv14.11.0, v11.14.0 (click for more details on Postgres versions)

Step 3: After you enter the above details, you'll be prompted to enter additional details such as persistence size, port number, etc. Refer to the below table for more information.

Postgres Advanced Options

Under the Advanced Options, enter the following details:

AuthenticationDescGeneralDesc
postgres user passwordPostgreSQL password for the postgres user when the username is not postgresport numberThe default port for Postgres is 5432, but it can be configured to listen on a different port using this setting.
usernamePostgreSQL username. default value if postgres
passwordPostgreSQL password
database namePostgreSQL database
ValueMasterReplicaDesc
persistence size8Gi*8Gi*This is a measure of size of a Postgres database and can vary depending on the amount and type of data stored, as well as the configuration of the Postgres instance.
existing persistence name--If you already have previous persistent volume claim and want to reuse it, you directly attach it using this setting.

*default value

Step:4 After you successfully fill in all the required details, click on Create and the Datasource creation process will start.

postgres-1

Picture representing the state of UI when all the details are entered.

Step 5: Once the Postgres Datasource is successfully created, you'll see them listed in the DataSources tab with details like:

a. Datasource Name b. Cluster Name c. Database used d. Database version used

Step 6: If you wish to delete the datasource, click on the vertical 3 dots next to the datasource card and click on Delete. This will initiate the deletion process.

Caution: Do not delete any datasource if you are not sure about it as it can lead to dataloss.

datasource_mongo-2

How to use existing datasources in a pipeline?

TBD

Troubleshooting

Need help? Contact us