Re: stop server - Mailing list pgsql-general
From | Roberto Sanchez |
---|---|
Subject | Re: stop server |
Date | |
Msg-id | CAAgrMNcdOnZ9x0WEC0AT+NRBRmrpQEBL3=aK-FsYbfs=eAEguA@mail.gmail.com Whole thread Raw |
In response to | Re: stop server (Raghavendra <raghavendra.rao@enterprisedb.com>) |
List | pgsql-general |
thanks, doesn't stop the server i think i have to reinstall postgresql
2012/1/3 Raghavendra <raghavendra.rao@enterprisedb.com>
On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez <trev21mx@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 installationSorry friend,, am new to homebrew... :)sudo /sbin/SystemStarter stop postgresql-9.1--RaghavEl 3 de enero de 2012 02:18, Raghavendra <raghavendra.rao@enterprisedb.com> escribió:2012/1/3 roberto sanchez muñoz <trev21mx@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 -miwaiting for server to shut down............................................................... failedpg_ctl: server does not shut downYour 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--RaghavEl 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,RaghavendraEnterpriseDB CorporationOn Tue, Jan 3, 2012 at 11:17 AM, Roberto Sanchez <trev21mx@gmail.com> wrote:show thisps -ef | grep postgres501 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.log501 1404 1402 0 0:00.00 ?? 0:00.00 postgres: writer process501 1405 1402 0 0:00.00 ?? 0:00.00 postgres: wal writer process501 1406 1402 0 0:00.00 ?? 0:00.00 postgres: autovacuum launcher process501 1407 1402 0 0:00.00 ?? 0:00.00 postgres: stats collector process501 1413 1329 0 0:00.00 ttys000 0:00.00 grep postgres501 1400 1397 0 0:00.00 ttys001 0:00.00 pg_ctl -D /usr/local/var/postgres stop -miEl 2 de enero de 2012 23:34, Raghavendra <raghavendra.rao@enterprisedb.com> escribió:Two things:1. See the output of the postgres process which are running with utility commands.ps -ef | grep postgres2. Also, take look in the logs for any information written on any process which is running and failing to abort.2012/1/3 roberto sanchez muñoz <trev21mx@gmail.com>still failing it showspg_ctl -D /usr/local/var/postgres stop -miwaiting for server to shut down............................................................... failedpg_ctl: server does not shut downEl 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 stoppg_ctl -D /usr/local/var/postgres stop -mi2012/1/3 roberto sanchez muñoz <trev21mx@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
pgsql-general by date: