Our disk capacity is at 100%. it seems our postgresql server is full. When I run the df command, I see this.

Filesystem     1K-blocks     Used Available Use% Mounted on
udev             4070824        0   4070824   0% /dev
tmpfs             816772     8888    807884   2% /run
/dev/vda1       81120644 81104264         0 100% /
tmpfs            4083848      360   4083488   1% /dev/shm
tmpfs               5120        0      5120   0% /run/lock
tmpfs            4083848        0   4083848   0% /sys/fs/cgroup
/dev/vda15        106858     3668    103190   4% /boot/efi
/dev/sda       103900088    61464  98579360   1% /mnt/volume_ams3_01
tmpfs             816768        0    816768   0% /run/user/0
tmpfs             816768        0    816768   0% /run/user/1001

You can also see that i have created a new volume. But i want to attach it to /dev/vda1 or basically increase space for postgresql. How can i do it?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

You are usually better off to host a database’s storage locally on the Droplet itself. This is because you do not want to introduce additional latency, or a potential networking issue between your database and where it writes information.

The recommended solution would be to upgrade your droplet to a larger one so that you have more disk space which is still local. Block storage wouldn’t be the recommended solution, especially for heavily utilized databases.

If the database is used infrequently you can attach a volume, but again it is recommended that you move the entire database to the new volume, you can’t “append” the volume to your local storage.

Alternatively you can also moved the database to our managed DB solution as well.

Submit an Answer