Missing primary keys after schema change in PostgreSQL to Amazon Redshift replication

Summary

When changes are made to the source schema in PostgreSQL and replicated to Amazon Redshift, primary keys in the destination schema are missing. How to fix this?


Question

I’ve established a connection between PostgreSQL and Amazon Redshift. When changes are made to the source schema, the corresponding changes are reflected in the destination schema. However, after the schema change, the primary keys in the destination are missing, even though the primary columns have not been removed from the altered schema how can i fix this ?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["postgresql", "amazon-redshift", "schema-change", "replication", "primary-keys"]