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...]
In this tutorial, we are going to find data directory and configuration files paths in PostgreSQL Server.
If environment variables configured, then we can get the data directory path by running below command on Linux Shell i.e.
echo $PGDATA. If it is not set then we have to execute SQL statements. 1. Find the data directory path in PostgreSQL Server.
select setting from pg_settings where name = 'data_directory';
Continue reading Find PostgreSQL data directory and configuration file location