Postgres
Please see before starting:
Kubemq postgres-aws target connector allows services using kubemq server to access postgres database services.
Prerequisites
The following are required to run the postgres-aws target connector:
kubemq cluster
aws rds with IAM user postgres server
db user with IAM Authentication privileges
kubemq-targets deployment
Configuration
Postgres target connector configuration properties:
Properties Key | Required | Description | Example |
max_idle_connections | no | set max idle connections | "10" |
max_open_connections | no | set max open connections | "100" |
connection_max_lifetime_seconds | no | set max lifetime for connections in seconds | "3600" |
db_user | yes | aws db user name | "<aws user" |
db_name | yes | aws db name | "<aws instance name" |
aws_key | yes | aws key | aws key supplied by aws |
aws_secret_key | yes | aws secret key | aws secret key supplied by aws |
region | yes | region | aws region |
token | no | aws token ("default" empty string | aws token |
end_point | yes | aws rds end point | "<aws rds end point" |
Example:
Usage
Query Request
Query request metadata setting:
Metadata Key | Required | Description | Possible values |
method | yes | set type of request | "query" |
Query request data setting:
Data Key | Required | Description | Possible values |
data | yes | query string | base64 bytes array |
Example:
Query string: SELECT id,title,content FROM post;
Exec Request
Exec request metadata setting:
Metadata Key | Required | Description | Possible values |
method | yes | set type of request | "exec" |
isolation_level | no | set isolation level for exec operation | "" |
"read_uncommitted" | |||
"read_committed" | |||
"repeatable_read" | |||
"serializable" | |||
Exec request data setting:
Data Key | Required | Description | Possible values |
data | yes | exec string | base64 bytes array |
Example:
Exec string:
Transaction Request
Transaction request metadata setting:
Metadata Key | Required | Description | Possible values |
method | yes | set type of request | "transaction" |
isolation_level | no | set isolation level for exec operation | "" |
"read_uncommitted" | |||
"read_committed" | |||
"repeatable_read" | |||
"serializable" |
Transaction request data setting:
Data Key | Required | Description | Possible values |
data | yes | string string | base64 bytes array |
Example:
Transaction string:
Last updated