Re: stop server

thanks, doesn't stop the server i think i have to reinstall postgresql

2012/1/3 Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>

>
>
> On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez <trev21mx(at)gmail(dot)com>wrote:
>
>> 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
>>
>>
> Sorry friend,, am new to homebrew... :)
> By googling, I found this...
>
> http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x
>
> sudo /sbin/SystemStarter stop postgresql-9.1
>
> --Raghav
>
>
>> 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
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>