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