I have a development postgresql that has been running a few weeks. However, over the weekend, it looks like it became unavailable.
ID PROCESS VERSION REGION DESIRED STATUS HEALTH CHECKS RESTARTS CREATED
afe2b24f app 0 sjc run running (failed to co) 3 total, 3 critical 1 2022-01-22T03:03:10Z
% fly logs is showed a no space left on device error, too.
2022-02-07T15:45:43.989 app[afe2b24f] sjc [info]keeper | 2022-02-07 15:45:43.989 UTC  PANIC: could not write to file “pg_wal/xlogtemp.825”: No space left on device
I was monitoring my DB size, and hoping to prevent banging against any limits, but I guess I failed.
Just wondering what my options are at this point?
It looks like by default the volume size was set to 1gb. Oops. I had assumed it was 3gb for the free test environment. Would it be possible for me to increase the size to 2gb or 3, so I can at least recover the data?
Cool. Thanks for the links. Im pretty sure it was just running out of the storage space. I did not realize it was allocated to just 1GB. Oh well. It def would be nice to get a warning, before having things break.
I am just evaluating and testing things out. Thus, no harm done. I guess for any others, just be careful about hitting storage limits!