# postgresql

### Upgrading postgres under docker

```javascript
docker run -it --rm --mount \
  type=bind,source=`pwd`/data-dir,target=/var/lib/postgresql \
  -e POSTGRES_PASSWORD=password \
  -e POSTGRES_USER=paperless \
  -e POSTGRES_DB=paperless \
  -e PGAUTO_ONESHOT=yes \
  pgautoupgrade/pgautoupgrade:18-debian
```