Thread: Single User mode

Single User mode

From
Theo Galanakis
Date:

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.

Re: Single User mode

From
"Joshua D. Drake"
Date:
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

Re: Single User mode

From
Theo Galanakis
Date:

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

Re: Single User mode

From
Gourish Singbal
Date:
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