Re: [GENERAL] stop server

2012-01-03 Thread Roberto Sanchez
thanks, doesn't stop the server i think i have to reinstall postgresql 2012/1/3 Raghavendra > > > On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez 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_lo

Re: [GENERAL] stop server

2012-01-03 Thread Roberto Sanchez
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 escribió: > 2012/1/3 roberto sanchez muñoz > >> i trie

Re: [GENERAL] stop server

2012-01-03 Thread Raghavendra
On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez 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 homebr

Re: [GENERAL] stop server

2012-01-03 Thread John R Pierce
On 01/02/12 10:10 PM, roberto sanchez muñoz wrote: i tried but still had the same error and i dont know how to see the logs /usr/local/var/postgres/server.log is probably your log, as thats what your PS output shows was the -r argument...its that or its in /usr/local/var/postgres/pg_log/

Re: [GENERAL] stop server

2012-01-03 Thread roberto sanchez muñoz
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 do

Re: [GENERAL] stop server

2012-01-03 Thread Raghavendra
2012/1/3 roberto sanchez muñoz > 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

Re: [GENERAL] stop server

2012-01-02 Thread Raghavendra
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:

Re: [GENERAL] stop server

2012-01-02 Thread roberto sanchez muñoz
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

Re: [GENERAL] stop server

2012-01-02 Thread Roberto Sanchez
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

Re: [GENERAL] stop server

2012-01-02 Thread Raghavendra
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: htt

Re: [GENERAL] stop server

2012-01-02 Thread Raghavendra
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

[GENERAL] stop server

2012-01-02 Thread roberto sanchez muñoz
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.postgr