The documentation is not clear about this specific logical replication scenario. It does mention unlogged tables on the publisher's side:

Only persistent base tables can be part of a publication. Temporary tables, unlogged tables, foreign tables, materialized views, regular views, and partitioned tables cannot be part of a publication. To replicate a partitioned table, add the individual partitions to the publication.

In my scenario, the table in the publisher is normal, while the table in the subscriber is unlogged.

Can I do this?

  • It sounds like you can. have you tried?
    – Jasen
    Commented Aug 3, 2018 at 11:27
  • Yes, and I got some erros, but they weren’t related in the end. I will try again soon
    – ivarec
    Commented Aug 3, 2018 at 14:07


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.