Articles in this section

See more

PostgreSQL: ERROR: unrecognized role option "createuser"

Avatar
Alisa Kasyanova
Updated
Follow

Applicable to:

  • Plesk for Linux

Symptoms

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

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

    0zmZV_croper_ru.png

    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: according to the Software Requirements (Supported Third-Party Components | Database servers and tools) PostgreSQL 9.6 is not supported.

Resolution

Reinstall PostgreSQL to the supported version:

  1. Connect to the server via SSH;

  2. Find the repository which provided 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

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

    # cat /etc/apt/sources.list | grep "debian.mirrors.ovh.net"
    # 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

  4. Find the installed postgresql packages:

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

  5. Remove these packages:

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

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

Comments

4 comments

Sort by Date Votes
  • Avatar
    Ody Light

    I tried to resolve it following your way. But i still got this error

    Note: i rinstalled postgressql 10 through plesk component installator

    1
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    @Ody, it seems that there is not enough information to resolve the issue on the fly.

    Please, consider contacting Plesk Technical Support.

    0
    Comment actions Permalink
  • Avatar
    Fatih Duman

    I also have the same issues.
    My output from the consol using Debian 9, with latest Plesk:

    postgresql
    postgresql-9.6
    postgresql-client-9.6
    postgresql-client-common
    postgresql-common
    postgresql-contrib-9.6

    When creating a new PostgreSQL I get this

    After clicking the button "Back to previous" I see this

    The Settings Pages looks like this

    Any suggestions?

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello Fatih Duman

    Unfortunately, the links no longer work.

    If the issue is still actual, please, consider contacting Plesk Technical Support.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles