Restart postgres in a docker environment

Question

I have troubles restarting a dockerized postgres database (I use Core OS). The database is started in a bash script using the command

# boot.sh
sudo -i -u postgres /usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf

which works. I have another script called by confd which is run when some etcd keys change (this part is ok, the file is correctly called) and must restart postgres (not reload, because some config changes require a restart). Here are the main options I tried, which failed...

# restart.sh
sudo -u postgres /usr/lib/postgresql/9.3/bin/pg_ctl --pgdata=/var/lib/postgresql/9.3/main restart

systematically raises an error:

%FATAL:  lock file "postmaster.pid" already exists
%HINT:  Is another postmaster (PID 273) running in data directory "/var/lib/postgresql/9.3/main"?

Furthermore,

# restart.sh
rm /var/lib/postgresql/9.3/main/postmaster.pid
sudo -i -u postgres /usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf

,

rm /var/lib/postgresql/9.3/main/postmaster.pid
/etc/init.d/postgresql start

,

/etc/init.d/postgresql restart

and

exec su postgres -c "/usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf"

fail with

ERROR exit status 1

Any thought? Thank you in advance!

On the one hand, a restart.sh consisting of only this line works without error on my Ubuntu server: sudo -i -u postgres /usr/lib/postgresql/9.3/bin/pg_ctl restart -D /var/lib/postgresql/9.3/main. (I don't see this syntax in your question.) On the other hand, I'm not running it in a Docker container. — Mike Sherrill 'Cat Recall'
– Mike Sherrill 'Cat Recall', Commented Nov 14, 2014 at 17:34
Thanks Mike, it does work on an ubuntu server. The problem seems to be tied to Core OS or Docker, but I do not know yet exactly in what it consist... — Raphael
– Raphael, Commented Nov 14, 2014 at 17:40

Risadinha · Accepted Answer · 2017-05-30 11:36:00Z

24

For me, changing the config and doing

$ docker restart <postgres_container>

on the host works just fine.

answered May 30, 2017 at 11:36

Risadinha

16.8k2 gold badges97 silver badges99 bronze badges

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

1 Comment

Risadinha Over a year ago

@MikhailM - docker sends a sigterm signal and only kills after so many seconds (default might be 10sec). If this is too short you can increase that time. See docs.docker.com/engine/reference/commandline/stop

Collectives™ on Stack Overflow

Restart postgres in a docker environment

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related