Hello everyone. When I want to restart my Postgres cluster,

Question

Hello everyone. When I want to restart my Postgres cluster,

I get the following error:
"Cluster is already running.
Can't open PID file /run/postgresql/15-main.pid (yet?) after start: Operation not permitted
Failed with result 'protocol'.
Failed to start PostgreSQL Cluster 15-main."

Actually, my cluster is actively working now, but my /var/run/postgresql/15-main.pid and /run/postgresql/15-main.pid files are missing.

How can I make the cluster restartable? or where do I need to add the "15-main.pid" file manually?

These are the last steps I did, the problem may be caused by these:

1.My cluster is version 15, but version 16 is also installed on the server.

2. I was working with pgbackrest. To change the stanza, I turned "archive_mode OFF" and restarted the server. There was no problem, but when I entered "archive_mode and archive_command" again, I could not restart the server.

#programming #russian

0

14.03.2024

1 ответов

41 просмотр

Sercan · Answer 1

Sercan Автор вопроса

My problem seems to be solved for now. I got the PID from "htop". I created the "/var/run/postgresql/15-main.pid" file manually with the "postgres" user. My cluster looks healthy for now and it can be restarted.

0

8 месяцев назад

169 похожих чатов

Hello everyone. When I want to restart my Postgres cluster,

1 ответов

Похожие вопросы