PGSync Table Permission Related Issue

[joshuafernandes1996]

Hi @toluaina ,

So we have a structure where each microservice will have its own database and database user. This DB User is granted certain privileges to perform sql operations.

We came to realize that PGSync also has its own tables and a PGSync user that accesses and updates those tables. The issue is, everytime the kubernetes Pod restarts, the privilges that were granted to that user gets revoked and the pguser is not able to perform any operations on the tables.

Do you know if this is intended? If yes, please can you help us with a workaround?

Kind Regards.

[toluaina]

pgsync creates a single materialized view named _view for caching tables primary and foreign keys. pgsync does not create or manage users/roles.

[toluaina]

would it be possible to grant permission to the Postgres user in kube config?