pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSingle 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