I was curious if there was a better way of killing the "postgres" process? I
needed to place out DB in single user mode Using "postgres". Once I had
finished and exited "postgres", I could not start up "pg_ctl" the database
as postgres was still running. Is there a elequant way then just using :
kill -9 [#postgres-pid#]?

Theo


__________________________________________________ ____________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright. If you
have received this email in error, please advise the sender and delete
it. If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone. You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.

Theo Galanakis wrote:

> I was curious if there was a better way of killing the "postgres"
> process? I needed to place out DB in single user mode Using
> "postgres". Once I had finished and exited "postgres", I could not
> start up "pg_ctl" the database as postgres was still running. Is there
> a elequant way then just using : kill -9 [#postgres-pid#]?
>
-TERM



> Theo
>
> __________________________________________________ ____________________
> This email, including attachments, is intended only for the addressee
> and may be confidential, privileged and subject to copyright. If you
> have received this email in error, please advise the sender and delete
> it. If you are not the intended recipient of this email, you must not
> use, copy or disclose its content to anyone. You must not copy or
> communicate to others content that is confidential or subject to
> copyright, unless you have the consent of the content owner.
>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Theo,

kill -9 [#postgres-pid#]? might be harmful to your database use one of
the below comands to shutsdown ur database when there are clients
connected and u want to shutdown ur server:-

/usr/local/pgsql/bin/pg_ctl -m smart stop
#Waits for all users to logout (Oracle analagous to Shutdown)
/usr/local/pgsql/bin/pg_ctl -m fast stop
# All active transactions get rolled back (Oracle analagous to
shutdown transactional)
/usr/local/pgsql/bin/pg_ctl -D data -m immediate stop
#Waits # Immediate shutdown will need recovery next time up (Oracle
analoguos shutdown abort)

Reffrence:- http://www.osmosislatina.com/postgres/part2_2.htm

Best
Gourish

On Wed, 22 Dec 2004 16:17:53 +1100, Theo Galanakis
<Theo.Galanakis@lonelyplanet.com.au> wrote:
>
>
> I was curious if there was a better way of killing the "postgres" process? I
> needed to place out DB in single user mode Using "postgres". Once I had
> finished and exited "postgres", I could not start up "pg_ctl" the database
> as postgres was still running. Is there a elequant way then just using :
> kill -9 [#postgres-pid#]?
>
> Theo
> __________________________________________________ ____________________
> This email, including attachments, is intended only for the addressee
> and may be confidential, privileged and subject to copyright. If you
> have received this email in error, please advise the sender and delete
> it. If you are not the intended recipient of this email, you must not
> use, copy or disclose its content to anyone. You must not copy or
> communicate to others content that is confidential or subject to
> copyright, unless you have the consent of the content owner.
>


--
Best,
Gourish Singbal

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org