Thread: stop server
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
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
2012/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
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.
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
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.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
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 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
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
On 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
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 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,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
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
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,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
On 01/02/12 10:10 PM, roberto sanchez muñoz wrote: > i tried but still had the same error and i dont know how to see the logs /usr/local/var/postgres/server.log is probably your log, as thats what your PS output shows was the -r argument... its that or its in /usr/local/var/postgres/pg_log/*.log where the filename is variable depending on postgresql.conf settings. -- john r pierce N 37, W 122 santa cruz ca mid-left coast
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 installation
Sorry friend,, am new to homebrew... :)
sudo /sbin/SystemStarter stop postgresql-9.1
--Raghav
El 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
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.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
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