Install PostgreSQL 14.7 on Linux

1. Install PostgreSQL 14.7 with the following commands.

   Important Run the commands as root.

   #Clean the YUM cache and update existing packages for your current Linux repository. Note that this makes system changes.
    
   yum clean all && yum update -y
   
   #Prepare the PostgreSQL repository and packages:
   yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-$(rpm -E %{rhel})-x86_64/pgdg-redhat-repo-latest.noarch.rpm
   
   #Update the packages in the repository:
   yum -y update
   
   #Install the PostgreSQL 14.7 packages:
   yum -y install postgresql14 postgresql14-server postgresql14-contrib

2. Update the file /usr/lib/tmpfiles.d/postgresql-14.conf to set the correct permissions for some PostgreSQL 14.7 folders. Open the file for editing, for example with vim or nano.

   #update this line:
   d /run/postgresql 0755 postgres postgres -
   			
   #to:
   d /run/postgresql 2777 postgres postgres - -

   Important Do not use the chmod command on any directories or files, edit this configuration file instead.

3. If you are upgrading from version 5.8.x to 5.9, you also have to update the configuration file of PostgreSQL 11 (/usr/lib/tmpfiles.d/postgresql-11.conf) as described in the previous step.
4. Reboot the server.

Tip The default PostgreSQL 14.7 path on RHEL/CentOS is /usr/pgsql-14.

1. Install PostgreSQL 14.7 with the following commands:

   Important Run the commands as root.

   
   sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
   
   wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
   
   apt-get update && apt-get upgrade -y
   
   apt-get install -y postgresql-14

2. Update the file /usr/lib/tmpfiles.d/postgresql-common.conf to set the correct permissions for some PostgreSQL 14.7 folders. Open the file for editing, for example with vim or nano.

   #update this line:
   d /run/postgresql 1775 postgres postgres -
   			
   #to:
   d /run/postgresql 2777 postgres postgres - -

3. Reboot the server.

Tip The default PostgreSQL 14.7 path on Debian/Ubuntu is /usr/lib/postgresql/14.

1. Install PostgreSQL 14.7 with the following commands:

   Important Run the commands as root.

   
   zypper addrepo https://download.postgresql.org/pub/repos/zypp/repo/pgdg-sles-15-pg14.repo
   
   zypper refresh
   
   zypper install postgresql14 postgresql14-server postgresql14-contrib

2. Update the file /usr/lib/tmpfiles.d/postgresql-14.conf to set the correct permissions for some PostgreSQL 14.7 folders. Open the file for editing, for example with vim or nano.

   #update this line:
   d /run/postgresql 0755 postgres postgres -
   			
   #to:
   d /run/postgresql 2777 postgres postgres - -

3. If you are upgrading from version 5.8.x to 5.9, you also have to update the configuration file of PostgreSQL 11 (/usr/lib/tmpfiles.d/postgresql-11.conf) as described in the previous step.
4. Reboot the server.

Tip The default PostgreSQL 14.7 path on Suse is /usr/lib/pgsql-14.