Skip to main content
4 votes
Accepted

Partial (filtered) replication in PostgreSQL

Multiple people suggested using the pglogical extension, which turned out to work really well for this use-case.
jeancochrane's user avatar
2 votes

Slony Replication in PostgreSQL

I would use some proxy in front of postgresql servers. I advise using HAProxy to proxy tcp traffic. Example configuration might look more or less like this: defaults mode tcp timeout connect ...
bigfoot's user avatar
  • 126
1 vote
Accepted

Slony Replication in PostgreSQL

Try this https://github.com/gplv2/haproxy-postgresql It will guide you to create a better check than tcp-check , which is worse than pgsql-check which does a logical one. The check here is to see if ...
Glenn Plas's user avatar
1 vote

Postgres Replication

At least exists three way to do this: 1. REPLICATION + VIEW / FDW You can create ON MASTER VIEW or FDW for table and VIEW / FDW will be replicate to slave. Something like : CREATE VIEW schema1....
Roman Tkachuk's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible