jj9987

Members
  • Posts

    11
  • Joined

  • Last visited

Everything posted by jj9987

  1. Howdy. Just deleting the Docker won't wipe your data, unless you specifically also delete the appdata folder (whether it is on the array or cache drive). So if the appdata is still there and you recreate the container (has to be the same major version of PostgreSQL), all the databases and the data should still be there. As for recovery, standard data recovery applies, but it is much harder to do with databases, since it is not just one file. And if part of it is missing, basically all is gone. You can add additional databases when you log in as superuser `postgres` and run `CREATE DATABASE <name>;`. Security-wise I'd also recommend to have different users with the necessary permissions (e.g. one user can only access one database etc). For auto-backups, you can run a cron job, that runs `pg_dump` or `pg_dumpall`. Alternatively you could use pgBackRest, but there is no template for it at this moment, it needs additional configuration and is more complicated. --- Made some changes to the templates: - BREAKING CHANGE: Database volume paths now include version tag, e.g. `/mnt/cache/appdata/postgresql10` so you can run multiple instances with different versions at the same time. - BREAKING CHANGE: PostgreSQL 10 template got changed, this could have broken stuff on old users. I am not familiar with the template changes on older versions. - Added PostgreSQL 12, 13 and 14 templates. - Container names changed to lowercase and includes version, e.g. `postgresql14`. This should make it easier for using in custom networks. - Brought the templates up to date with current schema version. Hopefully it is more user-friendly now. Feedback welcome. Sorry, it's been too long since I updated them.
  2. The upgrade is sorta complicated, you need both old and new binaries available, which the official docker images do not provide. Backup and restore might be more convenient and easier.
  3. It's absolutely okay to use one database instance with multiple databases for multiple apps. You will just have to create the new databases (and preferably also new roles) through the psql shell. Postgres upgrades can't be done by simply changing the version tags, they often have changes that require additional steps (e.g. pg_upgrade). So definitely don't use the latest tag. I changed the templates long time ago, haven't added newer templates to the repo though. Here's the information on how to do it: https://www.postgresql.org/docs/14/upgrading.html
  4. I started to use unRAID because it was a complete package. It includes well-tested software that was designed to be working together and do it reliably. Plus it came with community support. I would love to see VM snapshots being added in 2020. Would make testing and creating new base VMs (with some initial configuration) so much more convenient.
  5. Happy birthday! Unraid has really improved over the years and awesome features just keep coming and coming. Keep up the good work!
  6. Postgres 11 has some breaking changes apparently. Made a not-so-smart move to configure this to latest tag. I'll fix this to PostgreSQL 10 and create another template for Postgres 10.
  7. It shows all the Docker volumes, that you can usually see with "docker volume list". By default these get mounted to /var/lib/docker/volumes/[volume id]/_data and are used by the container internally. More on Docker volumes.
  8. Application: Docker Registry @ https://github.com/docker/distribution-library-image DockerHub: https://registry.hub.docker.com/_/registry/ GitHub: https://github.com/juusujanar/unraid-templates/blob/master/DockerRegistry.xml This template uses the official Docker Registry image to quickly set up your own private repository for storing Docker images. If you have any issues/questions/suggestions regarding this Docker or the template, feel free to contact here.
  9. Application: Portainer @ https://portainer.io/ DockerHub:https://hub.docker.com/r/portainer/portainer/ GitHub: https://github.com/juusujanar/unraid-templates/blob/master/Portainer.xml This template uses the official Portainer Docker image to quickly set up a Portainer instance. It is used for graphical Docker management and gives more information than unRAID itself. If you have any issues/questions/suggestions regarding this Docker or the template, feel free to contact here.
  10. Application: Redis @ https://redis.io/ DockerHub: https://hub.docker.com/_/redis/ GitHub: https://github.com/juusujanar/unraid-templates/blob/master/Redis.xml This template uses the official Redis Docker image to quickly set up a Redis cache instance according to your configuration. If you have any issues/questions/suggestions regarding this Docker or the template, feel free to contact here.
  11. Application: PostgreSQL @ https://www.postgresql.org/ DockerHub: https://hub.docker.com/_/postgres/ GitHub: - Version 10: https://github.com/juusujanar/unraid-templates/blob/master/PostgreSQL10.xml - Version 11: https://github.com/juusujanar/unraid-templates/blob/master/PostgreSQL11.xml - Version 12: https://github.com/juusujanar/unraid-templates/blob/master/PostgreSQL12.xml - Version 13: https://github.com/juusujanar/unraid-templates/blob/master/PostgreSQL13.xml - Version 14: https://github.com/juusujanar/unraid-templates/blob/master/PostgreSQL14.xml This template uses the official Postgres Docker image to quickly set up a relational database according to your configuration. If you have any issues/questions/suggestions regarding this Docker or the template, feel free to contact here. CHANGELOG (5th November 2021): - BREAKING CHANGE: Database volume paths now include version tag, e.g. `/mnt/cache/appdata/postgresql10` so you can run multiple instances with different versions at the same time. - BREAKING CHANGE: PostgreSQL 10 template got changed, this could have broken stuff on old users. I am not familiar with the template changes on older versions. - Added PostgreSQL 12, 13 and 14 templates. - Container names changed to lowercase and includes version, e.g. `postgresql14`. This should make it easier for using in custom networks. - Brought the templates up to date with current schema version. Previous changelogs: