Replication of postgres database at table level

Question

I am just wondering whether it would be possible to replicate only a table in a postgres database with another database instance. For example, lets say that I have a postgres instance running at hostA and another instance at hostB. Lets say i have a relation called "user" in a database called "database1" in hostA and i want to replicate this with a different database called "database2" at hostB. How can we go about it?

I was able to do it using "SQL Generator" from IntelliJ's DBMS tool(Data Grip). — gtiwari333
– gtiwari333, Commented Feb 26, 2024 at 17:20

user330315 · Accepted Answer · 2012-07-06 13:24:24Z

7

Slony-I can do this: http://slony.info/documentation/2.1/preface.html#INTRODUCTION

But Slony might be quite an overhead if it's really only a single table.

For just a single table you could write a trigger that updates the table on the other host through DbLink.

answered Jul 6, 2012 at 13:24

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Replication of postgres database at table level

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related