Articles in this section

PostgreSQL: ERROR: unrecognized role option "createuser" LINE 1

Plesk for Linux kb: technical

Applicable to:

  • Plesk for Linux

Symptoms

  • Changing the password for PostgreSQL returns this 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

  • If Ubuntu is used, backports source list may be enabled:

    # grep backports /etc/apt/sources.list
    ## Also, please note that software in backports WILL NOT receive any review
    deb http://archive.ubuntu.com/ubuntu/ jammy-backports main restricted universe multiverse

Cause

An unsupported version of PostgreSQL is installed.

Resolution

  1. Remove the unsupported version of PostgreSQL
  2. Disable any repositories or sources that install it
  3. Install a supported version
Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.