Tag - PostgreSQL

Upgrading PostgreSQL – Patroni Cluster and Switching from Python 2 to Python 3

upgrading postgresql python 3

Python 2 has officially completed its life as of Jan 1st, 2020 and the Python 2.x branch will not be maintained anymore. You might be seeing repeated notices of deprecation in log files and terminals like:

Shell

DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as […]

Read more

PostgreSQL Application Connection Failover Using HAProxy with xinetd

PostgreSQL Application Connection Failover Using HAProxy with xinetd

Recently we published a blog about a very simple application failover using libpq features which could be the simplest of all automatic application connection routing.  In this blog post, we are discussing how a proxy server using HAProxy can be used for connection routing which is a well-known technique with very wide deployment. There […]

Read more