8 days ago
Hello Railway Support,
Our production PostgreSQL database shows the following warning in the Backups tab:
"PITR status unknown — The live WAL archiving state could not be read."
PITR appears to be enabled, but the recovery window cannot be confirmed.
Could you please clarify:
- Is WAL archiving currently working?
- Are new recovery points being created?
- How can we verify the available recovery window?
- Is this a temporary dashboard issue or a problem with PITR itself?
We also receive "Plan limit of 10 backups per volume exceeded" when attempting to create a new volume backup.
We would like to verify recovery availability before applying a production database migration.
Thank you.
3 Replies
8 days ago
Your database's logs show it is still handing a new WAL segment to the archiver about once a minute (most recently around 01:19 UTC today). Those log lines show each push starting, not whether it finished uploading, so on their own they can't confirm that new recovery points are landing or what your current recovery window is. The logs also show occasional backup-watcher retries over the last two days because another archive process was already running.
To check this directly, run railway postgres pitr status --service <your Postgres service> with the CLI. It reports your PITR configuration, restore coverage and archiver health, and it reads the live state from the running container. If the Backups tab still can't read that state, the PITR section there won't show a confirmed restore range either, so use the CLI output to check the window before your migration. Details are in the PITR docs and the railway postgres reference.
The backup error happens because your plan allows 10 volume backups per volume and this volume already has 10. Delete an older backup you no longer need from the Backups tab, or with railway postgres pitr backup delete <id>, and then create the pre-migration backup.
Status changed to Awaiting User Response Railway • 8 days ago
7 days ago
Railway PostgreSQLのPITRについて確認をお願いします。
本番環境でPITRはenabled、Bucket wiredはyes、Archiverもenabledです。
WAL coverageおよびLast archived atは更新されていますが、Restorable up toが2026-11-12 08:53:57 UTCから更新されていません。
この表示は正常な仕様でしょうか。それとも復元可能範囲の更新に問題が発生している状態でしょうか。
本番DBのPrismaマイグレーションを予定しているため、現時点で復元可能な最新時刻と、PITRが正常に機能しているかをご確認いただきたいです。
Status changed to Awaiting Railway Response Railway • 7 days ago
7 days ago
Apologies, we only correspond in English. Please open a new thread in English.
Status changed to Closed Railway • 7 days ago