Install PostgreSQL 11 on Linux

1. Install PostgreSQL 11 with the following commands.

   #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 11 packages:
   yum -y install postgresql11 postgresql11-server postgresql11-contrib

2. Update the file /usr/lib/tmpfiles.d/postgresql-11.conf to set the correct permissions for some PostgreSQL 11 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. Reboot the server.

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

1. Install PostgreSQL 11 with the following commands:

   
   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-11

2. Update the file /usr/lib/tmpfiles.d/postgresql-common.conf to set the correct permissions for some PostgreSQL 11 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. Reboot the server.

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

1. Install PostgreSQL 11 with the following commands:

   
   zypper addrepo https://download.opensuse.org/repositories/server:database:postgresql/SLE_15_SP3/server:database:postgresql.repo
   
   zypper refresh
   
   zypper install postgresql11 postgresql11-server postgresql11-contrib

2. Update the file /usr/lib/tmpfiles.d/postgresql-11.conf to set the correct permissions for some PostgreSQL 11 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. Reboot the server.

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