pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Single User mode
4+ messages / 3 participants
[nested] [flat]

* Single User mode
@ 2004-12-22 05:17  Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
  0 siblings, 2 replies; 4+ messages in thread

From: Theo Galanakis @ 2004-12-22 05:17 UTC (permalink / raw)
  To: pgsql-admin


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.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Single User mode
@ 2004-12-22 05:44  Joshua D. Drake <jd@commandprompt.com>
  parent: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
  1 sibling, 0 replies; 4+ messages in thread

From: Joshua D. Drake @ 2004-12-22 05:44 UTC (permalink / raw)
  To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>; +Cc: pgsql-admin

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

Attachments:

jd.vcf (text/x-vcard, 283B) download begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: Single User mode
@ 2004-12-22 05:51  Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
  0 siblings, 0 replies; 4+ messages in thread

From: Theo Galanakis @ 2004-12-22 05:51 UTC (permalink / raw)
  To: 'Joshua D. Drake' <jd@commandprompt.com>; +Cc: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Single User mode
@ 2004-12-27 06:08  Gourish Singbal <gourish@gmail.com>
  parent: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
  1 sibling, 0 replies; 4+ messages in thread

From: Gourish Singbal @ 2004-12-27 06:08 UTC (permalink / raw)
  To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-12-27 06:08 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-22 05:17 Single User mode Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
2004-12-22 05:44 ` Joshua D. Drake <jd@commandprompt.com>
2004-12-27 06:08 ` Gourish Singbal <gourish@gmail.com>
2004-12-22 05:51 Re: Single User mode Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox