simon / Postgresql

Last active 1 month ago

simon revised this gist 1 month ago · 9feac29

1 file changed, 13 insertions

postgresql.md (file created)
@@ -0,0 +1,13 @@
1 + # postgresql
2 +
3 + ### Upgrading postgres under docker
4 +
5 + ```javascript
6 + docker run -it --rm --mount \
7 + type=bind,source=`pwd`/data-dir,target=/var/lib/postgresql \
8 + -e POSTGRES_PASSWORD=password \
9 + -e POSTGRES_USER=paperless \
10 + -e POSTGRES_DB=paperless \
11 + -e PGAUTO_ONESHOT=yes \
12 + pgautoupgrade/pgautoupgrade:18-debian
13 + ```