PostgreSQL: ERROR: unrecognized role option "createuser"

Symptoms

• PostgreSQL server was installed via Plesk > Tools & Settings > Updates and Upgrades > Add/Remove Components

• After filling authentication fields and pressing the button OK in Plesk > Tools & Settings > Database Servers > PostgreSQL > localhost

  

  the following error appears:

  PLESK_ERROR: Internal error:
  ERROR: unrecognized role option "createuser" LINE 1: create user "admin" password 'password' createdb createuser ^
  Message ERROR: unrecognized role option "createuser" LINE 1: create user "admin" password 'password' createdb createuser ^
  File DatabaseManagerPostgreSQL.php
  Line 375
  Type PleskFatalException

• Additional repositories which provide with unstable and test versions of packages are enabled on the server:

  # cat /etc/apt/sources.list | grep backports
  
  # jessie-backports, previously on backports.debian.org
  deb http://debian.mirrors.ovh.net/debian/ jessie-backports main
  deb-src http://debian.mirrors.ovh.net/debian/ jessie-backports main

• PostgreSQL 9.6 is installed on the server:

  # dpkg -l | grep postgresql
  
  postgresql
  postgresql-9.6
  postgresql-client-9.6
  postgresql-client-common
  postgresql-common
  postgresql-contrib-9.6

Cause

Unsupported PostgreSQL 9.6 is installed.

Resolution

According to the Software Requirements (Supported Third-Party Components | Database servers and tools) PostgreSQL 9.6 is not supported.

Reinstall PostgreSQL to the supported version:

1. Find the repository which provided with PostgreSQL 9.6:

   # apt-cache showpkg postgresql-9.6 | grep File
   
   File: /var/lib/apt/lists/debian.mirrors.ovh.net_debian_dists_jessie_backports_main_binary-amd64_Packages

2. Find mentioned repository in /etc/apt/sources.list and disable it:

   # cat /etc/apt/sources.list | grep "debian.mirrors.ovh.net"
   
   [BEFORE]
   
   # jessie-backports, previously on backports.debian.org
   deb http://debian.mirrors.ovh.net/debian/ jessie-backports main
   deb-src http://debian.mirrors.ovh.net/debian/ jessie-backports main
   
   [AFTER]
   
   # jessie-backports, previously on backports.debian.org
   #deb http://debian.mirrors.ovh.net/debian/ jessie-backports main
   #deb-src http://debian.mirrors.ovh.net/debian/ jessie-backports main

3. Find installed postgresql packages:

   # dpkg -l | grep postgresql
   
   postgresql
   postgresql-9.6
   postgresql-client-9.6
   postgresql-client-common
   postgresql-common
   postgresql-contrib-9.6

4. Remove found packages:

   # dpkg -r --force-depends postgresql postgresql-9.6 postgresql-client-9.6 postgresql-client-common postgresql-common postgresql-contrib-9.6

5. Install PostgreSQL server again via Plesk > Tools & Settings > Updates and Upgrades > Add/Remove Components