How can I replicate all tables in one schema in postgresql11?



  • I am using postgresql11 and I'd like to setup logical replication between two db instances. I have read the doc https://www.postgresql.org/docs/10/sql-createpublication.html .

    I see there is an option to set FOR ALL TABLES but it includes all tables under all schemas of the database. Is there a way for me to sync all tables under on particular schemas? I don't want to list of tables so looking for a solution to cover all tables automatically



  • This feature will be available in https://commitfest.postgresql.org/35/3139/ . (please don't use development version in production) So, there is no such feature in postgresql 11.


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2