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​
- Have a connected cloud provider
- Have a connected source code provider
- 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:
Field Desc Name name of your Datasource Select Cluster cluster name where you want your Datasource to be created Select DataSource choose database/cache of your choice Select Version v14.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:
Authentication | Desc | General | Desc | |
---|---|---|---|---|
postgres user password | PostgreSQL password for the postgres user when the username is not postgres | port number | The default port for Postgres is 5432, but it can be configured to listen on a different port using this setting. | |
username | PostgreSQL username. default value if postgres | |||
password | PostgreSQL password | |||
database name | PostgreSQL database |
Value | Master | Replica | Desc |
---|---|---|---|
persistence size | 8Gi* | 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.
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.
How to use existing datasources in a pipeline?​
TBD
Troubleshooting​
Need help? Contact us