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