In this article, we will see PostgreSQL Directory Layout and their purpose.
PostgreSQL Database Directory Layout
Installation Directory Layout:
•
PostgreSQL is typically installed
to /usr/local/pgsql or /var/lib/pgsql on linux.
•
C:\Program
Files\PostgreSQL\<version number> on windows.
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...]