Home / server / Questions / 247571
Accepted
Ali
Asked: 2011-03-16 03:50:05 +0800 CST

Server with a full disk! What can I do?

  • 772

I have an Ubuntu server running PostgreSQL and a very light weight custom web-server.

I knew this would happen but I was too busy, and now the disk has 0 bytes free. I don't need all the data in the database and I've already deleted lots of rows in some tables, but the space won't be freed until the database is "vacuumed", and to do the vacuum I need lots of free disk space.

What can I do? This is an Amazon EC2 instance.

hard-drive ubuntu disk-space-utilization postgresql

2 Answers

  1. Best Answer

    You could create a new EBS volume, attach it to the server, copy the postgres data to it (stopping postgres first of course) and then mount it at the same location as the old data. Make the EBS volume as big as you require and then some, and then restart postgres.

    • 1

  2. I second madhatter with a df -k output. Also, i'm not sure how Amazon EC2 works in these types of cases, but i'm sure more storage is an option.

    • 0