thanks, doesn't stop the server i think i have to reinstall postgresql 2012/1/3 Raghavendra <raghavendra....@enterprisedb.com>
> > > On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez <trev2...@gmail.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....@enterprisedb.com> escribió: >> >> 2012/1/3 roberto sanchez muñoz <trev2...@gmail.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 <trev2...@gmail.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....@enterprisedb.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 <trev2...@gmail.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 <trev2...@gmail.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@postgresql.org) >>>>>>>> To make changes to your subscription: >>>>>>>> http://www.postgresql.org/mailpref/pgsql-general >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>>> >>> >> >