Re: stop server

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
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
>