lean owl
I use n8n with postgres, doing some tests I downloaded the same file several times and it filled up postgres.
My question is what do I lose if I clean the volume, do I lose my credentials and workflows too?
I can no longer access it to make a backup.
turbid anvilBOT
lean owl
N/A
quasi ivy
I use n8n with postgres, doing some tests I downloaded the same file several tim...
All your data will be deleted and won't be possible to restore it
lean owl
Is it possible to access /var/lib/postgresql/data to delete the downloaded files?
I would like to increase the volume, but it is not enabling it.
There has to be a way out, I can't lose everything.
quasi ivy
Is it possible to access /var/lib/postgresql/data to delete the downloaded files...
You can use the file browser template, but I don't suggest navigating through DB data.
I will silenty tag @little tangle here and see if it's possible to expand your volume size.
lean owl
Project ID: 166d3751-42cb-4032-8849-ca8f64aac2f7
little tangle
what is the current size of your volume?
lean owl
I can resize the volume.
However, it fails when opening the n8n application.
little tangle
please answer the question
lean owl
It was 500 MB, I changed it to 1GB
little tangle
please confirm that for me
lean owl
little tangle
okay great, please explain what "it fails" means
lean owl
n8n application does not open
little tangle
is n8n running?
lean owl
no
little tangle
that would be the problem 😆
little tangle
what errors are you getting in the deployment logs
little tangle
English please
lean owl
inattention
little tangle
why have they crashed
lean owl
lean owl
yes, I removed the postgres image, I returned the image with :last.
now it works.
I'm a beginner.
thanks
I would still like to delete the files I downloaded and that filled up the memory.
How do I do this?
little tangle
please dont swap image tags if you dont know what you are doing, it can very easily lead to data loss, railway cant recover data if the user was at fault, luckily it didnt cause issues this time
little tangle
images are not stored in postgres
lean owl
I use n8n with postgres, doing some tests I downloaded the same file several tim...
I'm saying about this
little tangle
files are not stored in postgres
being a hobby user you can grow your volume to 5GB
lean owl
but that suddenly filled the postgres memory
lean owl
being a hobby user you can grow your volume to 5GB
ok. tanks
strange remnantBOT
lean owl
files are not stored in postgres
I did more testing by running the n8n workflow by downloading the PDF file from Google Drive and Postgres went from 534MB to 545MB. I would like to know how to do it for which file is saved in Postgre. Please
lean owl
See that every time I download a PDF file from Google Drive to n8n my Postgres database increases in size. I would like to understand if this was supposed to happen. I have 2000 PDFs to process and this increase that occurred was only with 2 PDFs.
open cairn
as brody said, files are not stored in postgres. use an object/cloud bucket like amazon’s S3
lean owl
What would this increase in volume be with each execution of the workflow then?
open cairn
are you storing any data about the pdf / accessing the database in any way? If not, it may just be coincidental
lean owl
Sorry for so many questions, I'm a beginner.
What I did was install N8N as shown in the image and I didn't do any configuration, I just accepted the default one to be able to use N8N.
It's no coincidence that I uploaded 393 PDFs, see the increase in volume in the image.
Can you tell me what I lose if I clean the volume?
If I clean it and redistribute Postgres, will it work normally again?
open cairn
Uploaded the pdfs to where? Where are they stored?
lean owl
pinecone, but it has nothing to do with uploading, because the volume increases when downloading the pdf binary from google drive to n8n.
