postgresql service down, "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
0
votes
1
answer
391
views
i on artix with runit postgresql have issues after starting
#sudo sv start postgresql
ok: run: postgresql: (pid 849) 1236s
#sudo -u postgres psql
psql: error: connection to server on socket "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
#sudo sv status postgresql
down: postgresql: 0s, normally up, want up; run: log: (pid 854) 1273s
primarily its starting, then after i check its status its prompting me that the service is down
sudo sv start postgresql
ok: run: postgresql: (pid 11583) 0s
sudo sv status postgresql
down: postgresql: 0s, normally up, want up; run: log: (pid 854) 59
/var/log/postgresql/@400000006611a7623ac93f6c.u
2024-04-06_19:09:52.09176 postgres: could not access the server configuration file "/var/lib/postgres/data/postgresql.conf": No such file or directory
when i start it manualy :
➜ postgresql sudo ./run
2024-04-07 21:21:42.964 GMT LOG: skipping missing configuration file "/var/lib/postgres/data/postgresql.auto.conf"
2024-04-07 21:21:42.964 GMT FATAL: "/var/lib/postgres/data" is not a valid data directory
2024-04-07 21:21:42.964 GMT DETAIL: File "/var/lib/postgres/data/PG_VERSION" is missing.
Asked by bazizi khaled
(3 rep)
Apr 7, 2024, 08:20 PM
Last activity: Apr 7, 2024, 09:36 PM
Last activity: Apr 7, 2024, 09:36 PM