|
In this episode of Scaling Postgres, we discuss the benefits of pg_receivewal, how to setup simple application failover, new pg_checksums and setting up pgBouncer. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/never-lose-a-postgresql-transaction-with-pg_receivewal/ https://www.percona.com/blog/2019/10/23/seamless-application-failover-using-libpq-features-in-postgresql/ https://techcommunity.microsoft.com/t5/Azure-Database-for-PostgreSQL/Auto-Failover-with-PostgreSQL-12/ba-p/917637 https://www.credativ.com/blog/pgchecksums-10-released https://www.enterprisedb.com/blog/pgbouncer-tutorial-installing-configuring-and-testing-persistent-postgresql-connection-pooling https://info.crunchydata.com/blog/monitoring-postgresql-clusters-in-kubernetes https://blog.panoply.io/a-beginners-guide-to-formatting-dates-in-sql http://postgis.net/2019/10/20/postgis-3.0.0/ https://www.alibabacloud.com/blog/using-postgresql-to-create-an-efficient-search-engine_595344 https://www.alibabacloud.com/blog/the-rum-index-and-full-text-search-using-postgresql_595343 https://www.alibabacloud.com/blog/using-the-built-in-and-custom-ranking-algorithms-of-postgresql-for-full-text-searches_595345 https://www.alibabacloud.com/blog/term-frequency-statistics-in-postgresql-full-text-searches_595342 |