How to upgrade from PostgreSQL 11 to 12

In this article, we will see how to upgrade from PostgreSQL 11 to 12 on CentSO or Redaht.

We have following options to upgrade from PostgreSQL 11 to 12:

Logical Dump/Restore
Binary In-Place Upgrades(pg_upgrade)
Logical Replication

In this article, we are going to upgrade PostgreSQL 11 to 12 using pg_upgrade binary.

pg_upgrade -b oldbindir -B newbindir -d oldconfigdir -D newconfigdir [option...]

Continue reading How to upgrade from PostgreSQL 11 to 12

How to upgrade from PostgreSQL 10 to 11

In this article, we will see how to upgrade from PostgreSQL 10 to 11 on CentSO or Redaht.

We have following options to upgrade from PostgreSQL 10 to 11:

Logical Dump/Restore
Binary In-Place Upgrades(pg_upgrade)
Logical Replication

In this article, we are going to upgrade PostgreSQL 10 to 11 using pg_upgrade binary.

pg_upgrade -b oldbindir -B newbindir -d oldconfigdir -D newconfigdir [option...]

Continue reading How to upgrade from PostgreSQL 10 to 11