Re: stop server - Mailing list pgsql-general

Also what are the last lines of logs showing.

Can you stop trying from the bin directory ...

$cd /usr/local/Cellar/postgresql/9.1.2/bin/

$./pg_ctl -D /usr/local/var/postgres stop -mi

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/

On Tue, Jan 3, 2012 at 11:17 AM, Roberto Sanchez <trev21mx@gmail.com> wrote:

show this  

ps -ef | grep postgres

  501  1402   100   0   0:00.10 ??         0:00.15 /usr/local/Cellar/postgresql/9.1.2/bin/postgres -D /usr/local/var/postgres -r /usr/local/var/postgres/server.log

  501  1404  1402   0   0:00.00 ??         0:00.00 postgres: writer process       

  501  1405  1402   0   0:00.00 ??         0:00.00 postgres: wal writer process       

  501  1406  1402   0   0:00.00 ??         0:00.00 postgres: autovacuum launcher process       

  501  1407  1402   0   0:00.00 ??         0:00.00 postgres: stats collector process       

  501  1413  1329   0   0:00.00 ttys000    0:00.00 grep postgres

  501  1400  1397   0   0:00.00 ttys001    0:00.00 pg_ctl -D /usr/local/var/postgres stop -mi

El 2 de enero de 2012 23:34, Raghavendra <raghavendra.rao@enterprisedb.com> escribió:

Two things:

1. See the output of the postgres process which are running with utility commands. 

      ps -ef | grep postgres

2. Also, take look in the logs for any information written on any process which is running and failing to abort.

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/

2012/1/3 roberto sanchez muñoz <trev21mx@gmail.com>

still failing it shows

pg_ctl -D /usr/local/var/postgres stop -mi

waiting for server to shut down............................................................... failed

pg_ctl: server does not shut down

El 02/01/2012, a las 23:09, Raghavendra escribió:

Seems, some process are still running and looking for database access.  

You can try unclean shutdown IMMEDIATE with below option by forcing all process to stop

pg_ctl -D /usr/local/var/postgres stop -mi

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/

2012/1/3 roberto sanchez muñoz <trev21mx@gmail.com>

how can i stop the server i use this in terminal (pg_ctl -D /usr/local/var/postgres stop -s -m fast) and show this pg_ctl: server does not shut down

thanks for your help
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general