Issues with putting dockerized Postgres OLTP database in read only

I have a dockerized postgres 9.3.5 OLTP instance that I’m going to update to 9.5.2. Instead of shutting it down and doing a pg_dumpal to a file and then load it I would like to spin up a new docker container and pipe the database pg_dumpall -h localhost -p [port] -U postgres | psql -h localhost -U postgres -p [port]. I’m thinking I could alter the postgresql.conf to be in read only mode. This would temporarily mess with my app but at least users could still SELECT. Is there a better way to go about this? Are there any big issues with putting in read only mode while I pipe the database over?

  • Build Docker Image From Go Code
  • Run a Docker Image as a Container
  • docker stop and remove container
  • Nginx proxy pass configuration docker
  • “correct” way to manage database schemas in docker
  • Missing Carriage Return in Docker for Mac Containers
  • port redirect to docker containers by hostname
  • Building Docker Images with Drone.io
  • Docker port forwarding stops working after ip of host machine is changed
  • Hyperledger Fabric with docker not storing data after restart
  • Docker image error: “/bin/sh: 1: [python,: not found”
  • Use Jupyter together with file share or mounted folder
  • Docker will be the best open platform for developers and sysadmins to build, ship, and run distributed applications.