Digital Ocean Block Storage & Dokku postgres about dokku-postgres HOT 5 CLOSED

Note: the data for our volumes is actually stored in /var/lib/dokku/services/postgres/SERVICE_NAME/data. You should mount the /var/lib/dokku/services directory instead.

from dokku-postgres.

Hi,

Dokku uses Docker to run postgres instances, all images and volumes are located under /var/lib/docker. You can take the following steps to transfer all Docker data to a block storage:

1. Stop all Dokku apps
2. Stop Docker daemon
3. Mount the block storage under a temporary path, for example: /mnt/block
4. mv /var/lib/docker/* /mnt/block/
5. umount /mnt/block
6. Add a fstab entry for the block storage to mount it under /var/lib/docker
7. mount /var/lib/docker
8. Check if it is mounted
9. Start Docker daemon
10. Start Dokku apps

from dokku-postgres.

Sorry to spam you guys, but I thought I'd write the steps here for future reference.
So here is what I did :

$ sudo dokku plugin:install https://github.com/dokku/dokku-postgres.git postgres
$ dokku ps:stop myapp
$ sudo service docker stop
$ sudo mkdir -p /mnt/vol1;
$ sudo mkfs.ext4 -F /dev/disk/by-id/scsi-0DO_Volume_volume-lon1-02 // Format volume
$ sudo mount -o discard,defaults /dev/disk/by-id/scsi-0DO_Volume_volume-lon1-02 /mnt/vol1;
$ mv /var/lib/dokku/services/* /mnt/vol1/
$ umount /mnt/vol1
$ echo /dev/disk/by-id/scsi-0DO_Volume_volume-lon1-02 /var/lib/dokku/services ext4 defaults,nofail,discard 0 0 | sudo tee -a /etc/fstab
$ sudo mount -o discard,defaults /dev/disk/by-id/scsi-0DO_Volume_volume-lon1-02 /var/lib/dokku/services;
$ sudo service docker start
$ dokku ps:rebuildall  

I am not too sure of the use of sudos, as I ended up having an issue with permissions. Dokku would be unable to write in services after I mounted it. A simple sudo chown -R dokku /var/lib/dokku/services/ solved it. Thank you for your help guys.

from dokku-postgres.

sorry to resurrect the old issue, but maybe you can help:

I'm using Dokku's Postgres plugin on DigitalOcean droplet with 160GB disk. I want to expand the disk using DO's block storage but I'm not sure if that is even possible. I want to leave my current Postgres data as is and just attach more volume.

Is it possible to attach DigitalOcean's block storage to already created Dokku's Postgres? So just to enlarge the space for Postgres needs.

from dokku-postgres.

@ohld this might be better suited as a question to Digitalocean support, as it's not directly related to the plugin. You could also try our github discussions.

from dokku-postgres.