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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

2012/1/3 roberto sanchez muñoz <trev21mx@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 <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 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 <trev21mx@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 <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
Blog: http://raghavt.blogspot.com/

On Tue, Jan 3, 2012 at 11:17 AM, Roberto Sanchez <trev21mx@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.rao@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 <trev21mx@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 <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

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 <trev21mx@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.rao@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 <trev21mx@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 <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 -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 <trev21mx@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.rao@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 <trev21mx@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 <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

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 -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 <trev21mx@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.rao@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 <trev21mx@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 <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 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... :)
By googling, I found this...

http://russbrooks.com/2010/11/25/install-postgresql-9-on-os-x

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 -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 <trev21mx@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.rao@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 <trev21mx@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 <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