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