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