• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Issue PostgresSQL

P

papahausa

Basic Pleskian
Server operating system version
AlmaLinux 9.5
Plesk version and microupdate number
18.0.68 Update #2
Hello. After postgressql installation from plesk i cant enable it.

Database server was created with error: The test connection to the database server has failed because of network problems: SQLSTATE[08006] [7] could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Screenshot_344.pngScreenshot_345.png
 
papahausa said:
Hello. After postgressql installation from plesk i cant enable it.

Database server was created with error: The test connection to the database server has failed because of network problems: SQLSTATE[08006] [7] could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
View attachment 28085View attachment 28086
Click to expand...

postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; preset: disabled)
Drop-In: /usr/lib/systemd/system/postgresql.service.d
└─respawn.conf
Active: activating (auto-restart) (Result: exit-code) since Mon 2025-03-31 13:53:55 CEST; 1s ago
Process: 89312 ExecStartPre=/usr/libexec/postgresql-check-db-dir postgresql (code=exited, status=0/SUCCESS)
Process: 89314 ExecStart=/usr/bin/postmaster -D ${PGDATA} (code=exited, status=1/FAILURE)
Main PID: 89314 (code=exited, status=1/FAILURE)
CPU: 83ms

Job for postgresql.service failed because the control process exited with error code.
See "systemctl status postgresql.service" and "journalctl -xeu postgresql.service" for details.
***** problem report *****
Warning: start service postgresql failed
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?



/usr/local/psa/admin/bin/pg_manage '--set-admin-password' 'admin' failed with message: Job for postgresql.service failed because the control process exited with error code.
See "systemctl status postgresql.service" and "journalctl -xeu postgresql.service" for details.
***** problem report *****
Warning: start service postgresql failed
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
 
[root@salmon ~]# rm -rf /var/lib/pgsql/data/*
[root@salmon ~]# postgresql-setup initdb
WARNING: using obsoleted argument syntax, try --help
WARNING: arguments transformed to: postgresql-setup --initdb --unit postgresql
* Initializing database in '/var/lib/pgsql/data'
* Initialized, logs are in /var/lib/pgsql/initdb_postgresql.log
[root@salmon ~]# export PSA_PASSWORD=***********
[root@salmon ~]# /usr/local/psa/admin/bin/pg_manage --create-admin-login admin
Job for postgresql.service failed because the control process exited with error code.
See "systemctl status postgresql.service" and "journalctl -xeu postgresql.service" for details.
***** problem report *****
Warning: start service postgresql failed
Error: Cannot start postgresql
1



-----------------
from journalctl -xeu postgresql.service

Subject: Automatic restarting of a unit has been scheduled
░░ Defined-By: systemd
░░ Support: Help and Support | AlmaLinux Wiki
░░
░░ Automatic restarting of the unit postgresql.service has been scheduled, as the result for
░░ the configured Restart= setting for the unit.
Mar 31 19:17:08 salmon.cloudhive.pro systemd[1]: Stopped PostgreSQL database server.
░░ Subject: A stop job for unit postgresql.service has finished
░░ Defined-By: systemd
░░ Support: Help and Support | AlmaLinux Wiki
░░
░░ A stop job for unit postgresql.service has finished.
░░
░░ The job identifier is 461630 and the job result is done.
Mar 31 19:17:08 salmon.cloudhive.pro systemd[1]: Starting PostgreSQL database server...
░░ Subject: A start job for unit postgresql.service has begun execution
░░ Defined-By: systemd
░░ Support: Help and Support | AlmaLinux Wiki
░░
░░ A start job for unit postgresql.service has begun execution.
░░
░░ The job identifier is 461630.
Mar 31 19:17:08 salmon.cloudhive.pro postmaster[281031]: 2025-03-31 19:17:08.656 CEST [281031] LOG: redirecting log output to logging collector process
Mar 31 19:17:08 salmon.cloudhive.pro postmaster[281031]: 2025-03-31 19:17:08.656 CEST [281031] HINT: Future log output will appear in directory "log".
Mar 31 19:17:08 salmon.cloudhive.pro systemd[1]: postgresql.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: Help and Support | AlmaLinux Wiki
░░
░░ An ExecStart= process belonging to unit postgresql.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Mar 31 19:17:08 salmon.cloudhive.pro systemd[1]: postgresql.service: Killing process 281032 (postmaster) with signal SIGKILL.
Mar 31 19:17:08 salmon.cloudhive.pro systemd[1]: postgresql.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: Help and Support | AlmaLinux Wiki
░░
░░ The unit postgresql.service has entered the 'failed' state with result 'exit-code'.
Mar 31 19:17:08 salmon.cloudhive.pro systemd[1]: Failed to start PostgreSQL database server.
░░ Subject: A start job for unit postgresql.service has failed
░░ Defined-By: systemd
░░ Support: Help and Support | AlmaLinux Wiki
░░
░░ A start job for unit postgresql.service has finished with a failure.
░░
░░ The job identifier is 461630 and the job result is failed.
 
/usr/local/psa/admin/bin/pg_manage '--set-admin-password' 'admin' failed with message: Job for postgresql.service failed because the control process exited with error code.
See "systemctl status postgresql.service" and "journalctl -xeu postgresql.service" for details.
***** problem report *****
Warning: start service postgresql failed
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
psql: error: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
 
You must log in or register to reply here.

Similar threads

A
Issue I can't create a db for postgresql
Replies
2
Views
1K
Kaspar
K
S
Resolved PostgreSQL 17 pg_dump Error on Windows Server 2022 with Plesk
Replies
4
Views
704
shadowscript
S
A
Question Plesk install in ubuntu
Replies
2
Views
943
alexk345
A
R
Issue Creating a Docker image with PostGresSQL
Replies
0
Views
2K
rtarson
R
O
Issue Keila Docker
Replies
1
Views
734
omokobsen
O
Back
Top