a year ago
Please help me to understand system crash. For some reason the Postgress node has abruptly run out of space. I attach screenshots. Increased the space, restarted (ReDeployed all the nodes), but nothing help.
Pinned Solution
a year ago
To reduce postgres size you’ll have to adjust or add some of the following variables:
https://docs.n8n.io/hosting/configuration/environment-variables/executions/
Basically have the data prune enabled and reduce the total time to delete or the number of executions or both.
21 Replies
a year ago
Here is the screenshots.
a year ago
You can check via df -h inside the Postgres that Railway actually mounted the expanded volume. Have you tried that?
testuser123
You can check via df -h inside the Postgres that Railway actually mounted the expanded volume. Have you tried that?
a year ago
They haven't grew their volume to begin with.
brody
They haven't grew their volume to begin with.
a year ago
That’s odd, I replicated the same thing and it worked for me. The volume was increased.
Then maybe it’s a hobby plan limitation.
testuser123
That’s odd, I replicated the same thing and it worked for me. The volume was increased. Then maybe it’s a hobby plan limitation.
a year ago
They have not attempted to grow their volume at all, they have not even pressed the button.
a year ago
Ouch 😂. Bro said he increased the space, which I presumed he meant the volume.
a year ago
Thank you for the answers.
Apparently, I misled you initially. I increased the RAM and CPU that were originally limited for the Postgress node (not DISK space).
A few questions. Please help me understand.
-
I only have a button in Postgres to increase from 500 MB to 250 GB. Why do I need that much? I understand it is a Hobbie plan limitation?
-
Why am I suddenly running out of space for the Postgres node? Although previously 2 months was enough for my several Workflows.
-
How can I remove unnecessary stuff in it, optimize it? And what and how in n8n is taking up space in Postgres?
a year ago
Another one. When I tried to push "Grow" button to resize maximum 500 MB to 1 GB there is an error.
Attachments
a year ago
That's likely related to the current outage. Wait to troubleshoot until it's resolved.
a year ago
And what means 10$ bounty in my topic? I have contacted community support before. There were no rewards for answers.
1topby
And what means 10$ bounty in my topic? I have contacted community support before. There were no rewards for answers.
a year ago
Railway pays the bounty. Not you.
samgordon
Railway pays the bounty. Not you.
a year ago
I see. Thanks. Now the maximum disk space size has increased from 500 MB to 1 GB. But Postgres has such an inscription about pause in deployments. Is it some kind of work on the server?
Attachments
a year ago
Guys, tell me please, what I need to do with Postgres in order not to delete my database? In N8N Primary, Work and Redis restarted and deployed after servers fall. Here is the screenshots.
Attachments
1topby
Guys, tell me please, what I need to do with Postgres in order not to delete my database? In N8N Primary, Work and Redis restarted and deployed after servers fall. Here is the screenshots.
a year ago
Your database is safe, don’t worry.
I recommend you upgrade to Pro so you can have backups. It’s really important.
Also, try rolling back to the latest version that you remember was working (just go to that deploy and click the rollback button)
testuser123
Your database is safe, don’t worry. I recommend you upgrade to Pro so you can have backups. It’s really important. Also, try rolling back to the latest version that you remember was working (just go to that deploy and click the rollback button)
a year ago
You mean last version deploy in Postgress settings?
testuser123
Can be, but also the primary and worker.
a year ago
Maybe you know some issues?
Why am I running out of space for the Postgres node? Although previously 2 months was enough for my several Workflows. What does the Postgres database space footprint depend on?
How can I remove unnecessary stuff in it, optimize Postgres database? And what and how in n8n is taking up space in Postgres?
a year ago
To reduce postgres size you’ll have to adjust or add some of the following variables:
https://docs.n8n.io/hosting/configuration/environment-variables/executions/
Basically have the data prune enabled and reduce the total time to delete or the number of executions or both.
a year ago
It works. Thanks for both advices (redeployment previous versions + adding some variables to Postgres.
Status changed to Solved chandrika • about 1 year ago
