From: Gourish Singbal <gourish@gmail.com>
To: Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Single User mode
Date: Mon, 27 Dec 2004 11:38:03 +0530
Message-ID: <674d1f8a0412262208551ec86d@mail.gmail.com> (raw)
In-Reply-To: <16C0CF355FA04944A69E5A4F5299D30B110EBC@ganesh.au.lpint.net>
References: <16C0CF355FA04944A69E5A4F5299D30B110EBC@ganesh.au.lpint.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: gourish@gmail.com, Theo.Galanakis@lonelyplanet.com.au
Subject: Re: Single User mode
In-Reply-To: <674d1f8a0412262208551ec86d@mail.gmail.com>
References: <16C0CF355FA04944A69E5A4F5299D30B110EBC@ganesh.au.lpint.net> <674d1f8a0412262208551ec86d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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