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
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:
-
Connect to the server via SSH;
-
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 -
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 -
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 -
Remove these packages:
# dpkg -r --force-depends postgresql postgresql-9.6 postgresql-client-9.6 postgresql-client-common postgresql-common postgresql-contrib-9.6
-
Install PostgreSQL server again via Tools & Settings > Updates and Upgrades > Add/Remove Components
Comments
4 comments
I tried to resolve it following your way. But i still got this error
Note: i rinstalled postgressql 10 through plesk component installator
@Ody, it seems that there is not enough information to resolve the issue on the fly.
Please, consider contacting Plesk Technical Support.
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?
Hello Fatih Duman
Unfortunately, the links no longer work.
If the issue is still actual, please, consider contacting Plesk Technical Support.
Please sign in to leave a comment.