PostgreSQL agent
Target PostgreSQL
Prerequisites
To have Gluesync working on your PostgreSQL instance you will need to have:
-
Valid user credentials with permission to read, and write to the target tables and respective database
Setup via Web UI
-
Hostname / IP Address: DNS record or IP Address of your server;
-
Port: Optional, defaults to
5432; -
Database name: Name of your target database;
-
Username: Username with read/write to database tables;
-
Password: Password belonging to the given username.
Updates with bulk operations during CDC
|
When Use bulk operations during CDC ( For the target table this has the following effects:
Entities whose target table has an identity (auto-increment) column ignore the option: their updates are always applied as |
Setup via Rest APIs
Here following an example of calling the Core Hub’s Rest API via curl to setup the connection for this Agent.
Connect the agent
curl --location --request PUT 'http://core-hub-ip-address/pipelines/{pipelineId}/agents/{agentId}/config/credentials' \
--header 'Content-Type: application/json' \
--header 'Authorization: ••••••' \
--data '{
"hostCredentials": {
"connectionName": "myAgentNickName",
"host": "host-address",
"port": 5432,
"databaseName": "db_name",
"username": "",
"password": "",
"maxConnectionsCount": 100,
"enableTls": true,
"certificatePath": "/myPath/cert.pem"
}
}'