Re: stop server

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(at)gmail(dot)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(dot)rao(at)enterprisedb(dot)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(at)gmail(dot)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(at)gmail(dot)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(at)postgresql(dot)org)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/mailpref/pgsql-general
>>>>
>>>
>>>
>>>
>>
>