Bucardo is an asynchronous PostgreSQL replication system, allowing for multi-source, multi-target operations. It was developed at Backcountry by Jon Jensen and Greg Sabino Mullane of End Point Corporation, and is now in use at many other organizations. Bucardo is free … Read More
Blog
Bufisa Blog
Follow along with us as we share our experiences in the industry - the highs, the lows, and everything that falls in between.
Create a symlink (soft link) for different PostgreSQL version
One of a setback of being database administrator is writing a full path for psql command or others. Imagine you have 3 or more postgresql version running in your computer, and for each time you want to connect to database … Read More
Upgrading PostgreSQL 9.5 to 13 using pg_upgrade
pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/reload typically required for major version upgrades, e.g., from 8.4.7 to the current major release of PostgreSQL. … Read More