Skip to content

Instantly share code, notes, and snippets.

@ohld
Created April 29, 2023 20:11
Show Gist options
  • Save ohld/a8efcf7064036ae75a45bef8cabde779 to your computer and use it in GitHub Desktop.
Save ohld/a8efcf7064036ae75a45bef8cabde779 to your computer and use it in GitHub Desktop.
Dokku Postgres Upgrade 11 to latest w/ PostGIS
dokku postgres:export DB | gzip -9 > DB.sql.gz
docker pull postgis/postgis:latest
export POSTGRES_IMAGE="postgis/postgis"
export POSTGRES_IMAGE_VERSION="latest"
dokku postgres:create DB
gunzip DB.sql.gz | dokku postgres:import DB
@ohld
Copy link
Author

ohld commented Nov 23, 2023

Transfer postgres backup from server to a server using your machine as a intermediate device (you also would have a local copy of a db).

scp root@host:~/DB.sql.gz .
scp DB.sql.gz root@new_host:~/.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment