How to soft reload postgresql 9.1 in ubuntu 12.04?

Question

PostgreSQL

So that the currently executing requests and requests in the queue do not die?
Is it possible to do a service prostgresql reload? Or will it kill current requests? In mysql it kills.
There is a recipe for 9.0
dasboot.ru/blog/?p=182
but I don't see pg_ctl in 9.1

Answer 1

pg_ctl is located in the /usr/lib/postgresql/VERSION/bin directory. But you can just do a reload. At least for official builds from apt.postgresql.org.

Answer 2

kill -SIGHUP id родительского процесса
So you can force most unix services to reread your config.

Answer 3

It just works for mesudo service postgresql restart

Answer 4

The documentation says that
In stop mode, the server that is running in the specified data directory is shut down. Three different shutdown methods can be selected with the -m option. "Smart" mode (the default) waits for all active clients to disconnect and any online backup to finish. If the server is in hot standby, recovery and streaming replication will be terminated once all clients have disconnected. "Fast" mode does not wait for clients to disconnect and will terminate an online backup in progress. All active transactions are rolled back and clients are forcibly disconnected, then the server is shut down. "Immediate" mode will abort all server processes immediately, without a clean shutdown. This will lead to a crash-recovery run on the next restart.
Why you don't see pg_ctl, I personally can't say.