My guess is that you had a problem with upgrading postgres. And I guess further that the upgrade failed because you ran out of disk space. If that’s correct, and you’re on Digital Ocean, you need to

add a volume big enough to hold 4X your database (you need 3X and a bit more to make the math less critical–500GB is < ten cents an hour).

move the database to the volume

reconfigure app.yml to use the volume for the database

run the upgrade

move the database back to the (faster) SSD

switch app.yml back to having data on SSD

remove volume

I’m very busy this week and am losing all day Thursday to travel. If my assessment above is
it’s an emergency and you want me to drop everything to fix it, I’ll do it for $600. You can pay for 4 hours of time here. See this page for instructions to install my ssh keys on your server.

Thanks for your reply, in fact am on vultr, and my website is new with 100 members and 120 posts only, i made a backup of my website few days ago and found its only 36MB, we are running on vultr with 2CPU and 4Gb ram and 60GB storage.

In that case, it should be much easier than I described. I’ll do it for half the previous offer. Email support@literatecomputing.com for me to do it, or provide the full output of the rebuild so that someone else can help you.