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.
- 211
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 ...
- 116
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 ...
- 296
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....
- 560
Only top scored, non community-wiki answers of a minimum length are eligible