Skip site navigation (1) Skip section navigation (2)

Re: Single User mode

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: Theo Galanakis <Theo(dot)Galanakis(at)lonelyplanet(dot)com(dot)au>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Single User mode
Date: 2004-12-27 06:08:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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)


On Wed, 22 Dec 2004 16:17:53 +1100, Theo Galanakis
<Theo(dot)Galanakis(at)lonelyplanet(dot)com(dot)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.

Gourish Singbal

In response to

pgsql-admin by date

Next:From: Spiegelberg, GregDate: 2004-12-27 14:27:53
Subject: Re: Pg_dump
Previous:From: kondo_yoDate: 2004-12-27 04:51:46
Subject: Question about PostgerSQL administration tool

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group