N/A

All your data will be deleted and won't be possible to restore it

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.

You can use the file browser template, but I don't suggest navigating through DB data.

I will silenty tag @Brody here and see if it's possible to expand your volume size.

Project ID: 166d3751-42cb-4032-8849-ca8f64aac2f7

what is the current size of your volume?

I can resize the volume.
However, it fails when opening the n8n application.

please answer the question

It was 500 MB, I changed it to 1GB

please confirm that for me

okay great, please explain what "it fails" means

n8n application does not open

is n8n running?

no

that would be the problem 😆

yes

I can't log into the application

I already did redploy but I can't access it

what errors are you getting in the deployment logs

I'll get

esta caindo o serviço

English please

inattention

why have they crashed

not sure why you removed the image?

you need to redeploy the crashed services

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?

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

ok

images are not stored in postgres

I'm saying about this

files are not stored in postgres

being a hobby user you can grow your volume to 5GB

but that suddenly filled the postgres memory

ok. tanks

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

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.

as brody said, files are not stored in postgres. use an object/cloud bucket like amazon’s S3

What would this increase in volume be with each execution of the workflow then?

are you storing any data about the pdf / accessing the database in any way? If not, it may just be coincidental

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?

Uploaded the pdfs to where? Where are they stored?

pinecone, but it has nothing to do with uploading, because the volume increases when downloading the pdf binary from google drive to n8n.

I’m sorry, but you’re really not making your problem clear. You’ve said that the volume increases while uploading, but now you’re saying it only happens when downloading?

What data does this postgres db store? How does your script interact with it? If everything is done correctly and your script just pulls the pdf into Google Drive without interacting with the db, the db’s volume size should not increase.