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