2 months ago
Hello.
My PostgreSQL database is stuck in recovery mode and can't reach a consistent state. Can you help force finish or unlock it?
2025-05-06 08:52:54.797 UTC [3519] FATAL: the database system is not yet accepting connections
2025-05-06 08:52:54.797 UTC [3519] DETAIL: Consistent recovery state has not been yet reached.
the database system is not yet accepting connections
2025-05-06 08:52:55.051 UTC [3520] FATAL: the database system is not yet accepting connections
2025-05-06 08:52:55.051 UTC [3520] DETAIL: Consistent recovery state has not been yet reached.
Failed to hard-delete executions
2025-05-06 08:52:55.821 UTC [3521] FATAL: the database system is not yet accepting connections
2025-05-06 08:52:55.821 UTC [3521] DETAIL: Consistent recovery state has not been yet reached.
2 Replies
2 months ago
Hello,
I'm sorry, but we cannot manage your database for you. All databases are unmanaged, and thus, it is up to the user to administer their database.
Best,
Brody
Status changed to Awaiting User Response railway[bot] • 2 months ago
24 days ago
Hello,
Force recovery completion - Connect to your PostgreSQL instance and run:
ALTER SYSTEM SET recovery_target_action = 'promote';
SELECT pg_reload_conf();
Create trigger file - Execute this command on your server:
sudo touch /var/lib/postgresql/data/recovery.trigger