Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 315799FB756 for ; Fri, 9 Mar 2007 14:58:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 40096-01 for ; Fri, 9 Mar 2007 14:58:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id AA7B29FB839 for ; Fri, 9 Mar 2007 14:58:38 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so1181841nfb for ; Fri, 09 Mar 2007 10:58:37 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QuiLDQVfHFTr+86ZuZnjzw2q2wpUV8y2s9qGwWWC1gXqRLXzPB0LZQNpJwbZAw4Phw7WDFq6+Qb+NTeVyvUpdj0y7GsPjy1F5xNpQByGMvpNkIOHDKJVu4CZdovQam/KiDJT7dzFbh2GC72pMBV8Od1O9jAZ+F2AeCvke4znEwo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=OjFmh+J5FGl1Tw5lCdTyuom/NHNl2Lv7n9brpuUoJjOWEnd637+wfnVJfGDvY+bb+vLImftJ394ky1TPshaopDfnoIDf85KgzpdczPCe+dZDHHpQhRmMHUXWWyTU0s9aoLXgdgqRnRLtWQQSS3VsebfenNoyuQk3Q/CjQpMyUxI= Received: by 10.114.75.1 with SMTP id x1mr638332waa.1173466716234; Fri, 09 Mar 2007 10:58:36 -0800 (PST) Received: by 10.114.166.8 with HTTP; Fri, 9 Mar 2007 10:58:36 -0800 (PST) Message-ID: Date: Fri, 9 Mar 2007 13:58:36 -0500 From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" To: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [SQL] Running in single instance mode In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <321.1173457766@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/48 X-Sequence-Number: 24872 On 3/9/07, Karthikeyan Sundaram wrote: > Hi Everybody, > > We are using postgres 8.1.0. I want to do some maintenance work. > Hence, I want to run postgres in single user mode so that external people > won't be able to access the database. > > How can I run the postgres in single user mode?. Any idea? > > Regards > skarthi See: http://www.postgresql.org/docs/8.2/static/app-postgres.html