In this article, we will see how to set PostgreSQL environmental variables permanently in Ubuntu Linux step by step.
Continue reading How to set PostgreSQL environmental variables permanently in Ubuntu Linux
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...]
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...]