Re: stop server

no when i use /usr/local/var/postgres/pg_log directory show me
this /usr/local/var/postgres/pg_log/-bash: /usr/local/var/postgres/pg_log/:
No such file or directory and i use the homebrew installation

El 3 de enero de 2012 02:18, Raghavendra
<raghavendra(dot)rao(at)enterprisedb(dot)com>escribió:

> 2012/1/3 roberto sanchez muñoz <trev21mx(at)gmail(dot)com>
>
>> i tried but still had the same error and i dont know how to see the logs
>> $ cd /usr/local/Cellar/postgresql/9.1.2/bin/
>> $ ./pg_ctl -D /usr/local/var/postgres stop -mi
>> waiting for server to shut
>> down............................................................... failed
>> pg_ctl: server does not shut down
>>
>>
> Your logs will be in /usr/local/var/postgres/pg_log directory.
> Take the last log file of last few lines.
>
> If you have installed PostgreSQL with one-click installer then stop with
> /etc/init.d/postgresql-9.1 stop
>
> --Raghav
>
>
>
>
>
>
>> El 02/01/2012, a las 23:54, Raghavendra escribió:
>>
>> 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
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>>
>