Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread Melvin Davidson
On Sat, Nov 26, 2016 at 2:52 PM, twoflower wrote: > That makes perfect sense. > > Thank you for a great help, Adrian! > > > > -- > View this message in context: http://postgresql.nabble.com/ > pg-ctl-restart-does-not-terminate-tp5932070p5932095.html > Sent from the PostgreSQL - general mailing li

Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread twoflower
That makes perfect sense. Thank you for a great help, Adrian! -- View this message in context: http://postgresql.nabble.com/pg-ctl-restart-does-not-terminate-tp5932070p5932095.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list

Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread Adrian Klaver
On 11/26/2016 11:33 AM, twoflower wrote: Ah, it didn't occur to me to try hitting ENTER. Still, this would be fine for manually running the script, but as I am restarting the server as a part of SaltStack config, I need |pg_ctl| to terminate without me intervening. The solution with the |-l| arg

Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread twoflower
Ah, it didn't occur to me to try hitting ENTER. Still, this would be fine for manually running the script, but as I am restarting the server as a part of SaltStack config, I need pg_ctl to terminate without me intervening. The solution with the -l argument is fine, I think. Even if I use it, the s

Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread Adrian Klaver
On 11/26/2016 11:08 AM, twoflower wrote: Yes, I am using that, thank you. But just by themselves these settings do not make |pg_ctl| terminate. You should see something like: postgres@panda:~> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data/ restart waiting for server to shut down.

Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread twoflower
Yes, I am using that, thank you. But just by themselves these settings do not make pg_ctl terminate. -- View this message in context: http://postgresql.nabble.com/pg-ctl-restart-does-not-terminate-tp5932070p5932090.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread Adrian Klaver
On 11/26/2016 07:47 AM, twoflower wrote: > Adrian Klaver-4 wrote >> You also specify a log file to pg_ctl by using -l: >> >> https://www.postgresql.org/docs/9.5/static/app-pg-ctl.html > > This did the trick, thank you! Great. Still I would suggest using the settings here: https://www.postgresql

Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread twoflower
Adrian Klaver-4 wrote > You also specify a log file to pg_ctl by using -l: > > https://www.postgresql.org/docs/9.5/static/app-pg-ctl.html This did the trick, thank you! -- View this message in context: http://postgresql.nabble.com/pg-ctl-restart-does-not-terminate-tp5932070p5932076.html Sen

Re: [GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread Adrian Klaver
On 11/26/2016 07:15 AM, twoflower wrote: I am restarting the server using the following: su postgres -c "/usr/lib/postgresql/9.6/bin/pg_ctl -D /var/lib/postgresql/9.6/main -o '-c config_file=/etc/postgresql/9.6/main/postgresql.conf' restart" The server is restarted properly, but the the comman

[GENERAL] 'pg_ctl restart' does not terminate

2016-11-26 Thread twoflower
I am restarting the server using the following: su postgres -c "/usr/lib/postgresql/9.6/bin/pg_ctl -D /var/lib/postgresql/9.6/main -o '-c config_file=/etc/postgresql/9.6/main/postgresql.conf' restart" The server is restarted properly, but the the command never finishes. After the restart, it displa