• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • Our UX team believes in the in the power of direct feedback and would like to invite you to participate in interviews, tests, and surveys.
    To stay in the loop and never miss an opportunity to share your thoughts, please subscribe to our UX research program. If you were previously part of the Plesk UX research program, please re-subscribe to continue receiving our invitations.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

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

H
Resolved PostgreSQL Installed in Plesk but Not Selectable for Database Creation
Replies
1
Views
435
Sebahat.hadzhi
Sebahat.hadzhi
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
477
shadowscript
S
A
Question Plesk install in ubuntu
Replies
2
Views
851
alexk345
A
S
Issue cannot connect to remote mysql form specific docker container
Replies
0
Views
410
stefanoostwegel
S
Back
Top