Resolved [PPP-48341] Unable to create PostgreSQL service

[simoncsc]

Hi,

I installed PostgreSQL sever on my latest version plesk with Centos 7, but couldn't start the service, here is the captured screen.

I click on the localhost(PostgreSQL), then enter the username and password, after clicking OK, the screen is displayed as below:

then I followed the instructions to type these two command via SSH "systemctl status postgresql.service" &
"journalctl -xe" , below is the output:



Any body can help me to fix this problem?

Best regards,

Simon

 

[abashurov]

@simoncsc,

Seems like the PostgreSQL instance is not initialized (as it reports empty data directory error). Seems like we don't initialize it anymore after installation, which is reported as bug with ID PPP-48341.

It should work if you run postgresql-setup initdb manually in console and only then then add the database server to Plesk.

 

[simoncsc]

Thank you for your reply, I run the command your provided, but fail, below is the error message and initdb log.



does it means I need to create a user "postgres" to run the command?

 

[simoncsc]

Hi

I have fixed the problem, solution: remove postpresql > delete folder /var/lib/pgsql > re-install postpresql > run postgresql-setup initdb

 

[IgorG]

Fixed in Plesk 18.0.27 Change Log for Plesk Obsidian