Mirror

PostgreSQL

Closed Beta

This feature is in closed beta and only available for our enterprise customers.

Please contact us at support@goldsky.com to request access to this feature.

Pipeline configuration

{
  "sources": [],
  "transforms": [],
  "sinks": [
    {
      "description": "Type.Optional(Type.String())",
      "type": "postgres",
      "sourceStreamName": "Type.String()",
      "schema": "Type.String()",
      "table": "Type.String()",
      "secretName": "Type.String()"
    }
  ]
}

Secrets

Create a PostgreSQL secret with the following CLI command:

goldsky secret create A_POSTGRESQL_SECRET --type jdbc --value '{
  "protocol": "postgresql",
  "host": "Type.String()",
  "port": "Type.Optional(Type.Integer())",
  "databaseName": "Type.String()",
  "user": "Type.String()",
  "password": "Type.String()",
}'
Previous
Sinks