Thread: Single User mode
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
Attachment
The heart of the matter was that I did not exit postgres correctly using Ctl-D. It still kept postgres alive.
Theo
-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Wednesday, 22 December 2004 4:45 PM
To: Theo Galanakis
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN] Single User mode
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
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