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?
Subscribe
Share
Submit an 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 to AnswerThese 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.
Try DigitalOcean for free
Click below to sign up and get $100 of credit to try our products over 60 days!
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.