How to add volume to /dev/vda1 for increased postgresql space?

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?

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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.