DOCKER container with postgres, WARNING: could not open statistics file “pg_stat_tmp/global.stat”: Operation not permitted

Question

Simple and dumb

I’ve tried another way: leaving the temporary file in container, where you need not deal with user permissions – and that worked. I’ve changed with inline command the Postgresql config in docker-compose.yml:

postgresdb:    
    image: 'postgres'
    command: postgres -c stats_temp_directory=/tmp
    .
    .
    .

This is quick and simple solution, but it does not set multiple postgres config parameters. Through the time I found another solution.

Advanced (added on 22/01/14 09:00PM CET)

The advanced solution consists in these steps:

Prepare your desired postgresql.conf – here you can set whichever postgres server parameters you need. The necessary one for solving problem in this thread is:

stats_temp_directory = '/tmp/stat_temporary'

Create bash file, that you will start using docker-entrypoint-initdb.d in docker-compose.yml with which you will copy your configuration to postgres config directory in docker and create your temporary folder.

If you setup the docker-compose.yml this way:

postgres-db:
    image: postgres
    container_name: 'dbcontainer'
    volumes:
      # point to your postgres init scripts (folder or file)
      - $PWD/db_init:/docker-entrypoint-initdb.d
      # if you need persistent data, point data to local folder
      - $PWD/database:/var/lib/postgresql/data
      # if you want some data restore, point to your backup
      - $PWD/db_backup:/db_backup
      # point docker to directory with your config
      - $PWD/db_config:/db_config

Then database will init with scripts in db_init directory. (Or you can point directly to one sql or bash file. If you point to directory, init script will run all files in alphabetical order.
Your file with init bash script, that you will place in your db_init folder can look like this and will be started inside docker:

echo starting script...
# create temporary directory for postgres in docker
mkdir /tmp/stat_temporary 

# copy your postgresql.conf to postgresql config location in docker
cp /db_config/postgresql.conf var/lib/postgresql/data/postgresql.conf

# alternatively you can run any pg script you need, here I restore backup to new database
pg_restore -U postgres -v -Fc -d analysis /db_backup/analysis_backup.bak
echo finished

After this script is run, the database service on docker is restarted and loads with new parameters you set up.

Leave a Comment Cancel reply