X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 37C443F84A3 for ; Mon, 27 Dec 2004 06:08:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65877-09 for ; Mon, 27 Dec 2004 06:08:05 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by svr1.postgresql.org (Postfix) with ESMTP id 9AADC3F84BB for ; Mon, 27 Dec 2004 06:08:04 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id i8so364597rne for ; Sun, 26 Dec 2004 22:08:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=gXh7iFdlGT9FTRW8JYRdHc/VyctdiBvntThxZErBfltq/LvUAQ3l6/cndjRqqp4fAeQAyeeDESK93X5YtJPuoTd6LBSNn6NMCamToBUGz3mI28P7fm4j2V0Gs93uoFMxgmBK+7LlIf+uQnTib9QfBriaXStaH07j6ls4qNuvFS8= Received: by 10.38.101.66 with SMTP id y66mr745439rnb; Sun, 26 Dec 2004 22:08:03 -0800 (PST) Received: by 10.38.97.69 with HTTP; Sun, 26 Dec 2004 22:08:03 -0800 (PST) Message-ID: <674d1f8a0412262208551ec86d@mail.gmail.com> Date: Mon, 27 Dec 2004 11:38:03 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: Theo Galanakis Subject: Re: Single User mode Cc: "pgsql-admin@postgresql.org" In-Reply-To: <16C0CF355FA04944A69E5A4F5299D30B110EBC@ganesh.au.lpint.net> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <16C0CF355FA04944A69E5A4F5299D30B110EBC@ganesh.au.lpint.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.084 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/245 X-Sequence-Number: 15831 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 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