DNS

Web Admin https://example-dns.example.me/ - Access to here can be controlled through nginx reverse proxy via ip or http auth/openldap. right now it's open.

ssh -p 10022

• example-ns0 example.me 10.50.3.30 powerdns postgres master
• example-ns1 example.me 10.50.4.31 powerdns postgres replication server 1 - 53 DNAT 216.83.154.107
• example-ns2 example.me 10.50.4.32 powerdns postgres replication server 2 - 53 DNAT 216.83.154.106
• PowerDNS https://www.powerdns.com/
• PostgreSQL 10
• PowerAdmin https://www.poweradmin.org/

ns0 runs postgresql "master" it's then doing logical replication to the other two postgres servers that authoritative queries are made to.

Don't know what logical replication is? While you're used to streaming replication you might want to check it out.

• https://www.postgresql.org/docs/10/logical-replication.html
• https://wiki.postgresql.org/wiki/Streaming_Replication
• https://severalnines.com/blog/postgresql-streaming-replication-vs-logical-replication