Issue I can't create a db for postgresql

[asukita]

Server operating system version

AlmaLinux 8.9

Plesk version and microupdate number

Plesk Obsidian Web Pro Edition 18.0.58 Update #2

Hi

I have recently purchased a pro account. When I am going to create a database for postgresql I get the next warning message

Database server was created with error: The test connection to the database server has failed because of network problems: SQLSTATE[08006] [7] FATAL: Peer authentication failed for user "root"

In Tools & Setting / Plesk Component I can see postgresql-server installed

postgresql-server

10.23-4.module_el8.9.0+3736+952d0ed7.alma.1

Thanks in advanced

 

[Kaspar]

In Tools & Setting / Plesk Component I can see postgresql-server installed

postgresql-server

10.23-4.module_el8.9.0+3736+952d0ed7.alma.1

That's the Plesk module for PostgreSQL. Not the actual Plesk component which installs the PostgreSQL service.

You can install the PostgreSQL component following this support article:

https://support.plesk.com/hc/en-us/articles/12377969757591--How-to-install-uninstall-Plesk-components

After which you can configure PostgreSQL as a database server in Plesk following this support article:

https://support.plesk.com/hc/en-us/articles/12377866155031-How-to-install-and-enable-PostgreSQL-database-server-in-Plesk

EDIT: see post below

 

[Kaspar]

On second thought, it does actually look like you've successfully installed the Plesk PostgreSQL server component.

Are you using the servers Root credentials to access PostgreSQL? Are you able to login to Plesk with the same Root credentials?