0

I have setup Google DataStream to replicate data from PostgresSQL using CDC. It works fine, but I have noticed that all character varying columns are not being replicated. I can see them in the source schema, but the destination table that been created it doesn't have that column at all.

Akram
  • 453
  • 4
  • 21
  • Hi @Akram, did you excluded the data while configuring information about the source database as mentioned in this [documentation](https://cloud.google.com/datastream/docs/create-a-stream#configuresourcedb)? – Shipra Sarkar Jan 27 '23 at 12:59

2 Answers2

0

Akram - if I am not mistaken you will see the new column only AFTER you add some data to that column. The same applies to new tables created in source DB (in case you select the option to replicate all new tables when setting up replication publication in PostgreSQL)

Yuriy Sychov
  • 1
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Mar 01 '23 at 22:19
0

At the moment Datastream for Postgresql has "Public preview" status and does not yet support the replication of "character varying []" (and if I'm not mistaken "citex" as well) Postgresql data types.

Denis Kotnik
  • 1
  • 2
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Mar 01 '23 at 22:29