Overriding a single configuration in a Postgres Docker container

Question

I'm trying to override a single item in the Postgres configuration of the official Docker Postgres image. Namely, I want to override the log_statement property and set it to all.

Tried it with:

docker run -d -e POSTGRES_PASSWORD=postgres postgres -c 'log_statement=all'

After enter the docker container and execute:

cat /var/lib/postgresql/data/postgresql.conf | grep log_statement

is still get the default value which is none.

but without success.

There are a few answers/questions regarding Postgres Docker configuration but they suggest replacing the complete postgresql.conf file.

It is a temporary override, in effect, and not actually modifying the configuration file. — Константин Ван
– Константин Ван, Commented Jun 14 at 11:59

b0gusb · Accepted Answer · 2019-05-23 11:10:09Z

2

From the docs:

Command-line options override any conflicting settings in postgresql.conf. Note that this means you won't be able to change the value on-the-fly by editing postgresql.conf, so while the command-line method might be convenient, it can cost you flexibility later.

As far as I understand that doesn't change the postgresql.conf but it actually runs the postgres command with the desired options. That's probably why you don't see the value set to all in the configuration file.

Hope it helps.

answered May 23, 2019 at 11:10

b0gusb

4,8492 gold badges19 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Siyavash vaez afshar · Accepted Answer · 2019-05-22 10:21:58Z

0

My solution is to mount Postgres config file somewhere on the server and edit it.

answered May 22, 2019 at 10:21

Siyavash vaez afshar

1,50313 silver badges13 bronze badges

Comments

Schwarz54 · Accepted Answer · 2019-05-22 10:52:46Z

0

I test your question in my pc. In the postgresql.conf log_statement="none" is commented. Go manually and discomment it and it solve your problems.

docker exec -it postgres bash

Into the container:

apt update
apt install vim
vim /var/lib/postgresql/data/postgresql.conf
search what do you are looking for and change it manually.
Stop/start the container.

That is my solution.

edited May 22, 2019 at 10:52

answered May 22, 2019 at 10:25

Schwarz54

1,0141 gold badge10 silver badges18 bronze badges

2 Comments

Bernard Over a year ago

This requires manual intervention every time the container is restarted.

Schwarz54 Over a year ago

No, with one time is enough, ensure you test the solutions before comment.

Collectives™ on Stack Overflow

Overriding a single configuration in a Postgres Docker container

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related