a month ago
PostgresSql volume is 100% full, database wont start, no backsups, need temporary access to free space. I had deployed n8n and have not locally downloaded the workflows
Pinned Solution
a month ago
Try expanding the volume capacity by clicking the volume that’s mounted to the service, then go to the settings tab, and redeploy after doing so.
If you’ve reached the max value for your plan, try setting the Postgres service’s command to sleep infinity, then access the console (enable priority boarding at https://railway.com/account/feature-flags) to create and download a dump.
3 Replies
a month ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • about 1 month ago
a month ago
you can select the Postgres volume and change the size from the settings
a month ago
Try expanding the volume capacity by clicking the volume that’s mounted to the service, then go to the settings tab, and redeploy after doing so.
If you’ve reached the max value for your plan, try setting the Postgres service’s command to sleep infinity, then access the console (enable priority boarding at https://railway.com/account/feature-flags) to create and download a dump.
a month ago
You could also try to connect and check what's eating space. Add a TCP Proxy to the Postgres service (Settings -> Networking), then connect with any GUI client (DBeaver, etc.) using the proxy host/port. Confirm the culprit with this command:
SELECT pg_size_pretty(pg_total_relation_size('execution_data'));
Then free up space by pruning execution data (Not workflows):
TRUNCATE TABLE execution_data RESTART IDENTITY CASCADE;
Then add those n8n env variables to stop it from happening again.
EXECUTIONS_DATA_PRUNE=true
EXECUTIONS_DATA_MAX_AGE=168
EXECUTIONS_DATA_PRUNE_MAX_COUNT=10000
Status changed to Solved 0x5b62656e5d • 16 days ago