From: Brad Nicholson <bnichols@ca.afilias.info>
To: andy.shellam-lists@mailnetwork.co.uk
Cc: Karthikeyan Sundaram <skarthi98@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Running in single instance mode
Date: Fri, 09 Mar 2007 14:01:11 -0500
Message-ID: <1173466872.5446.2.camel@dba5.int.libertyrms.com> (raw)
In-Reply-To: <45F1A4CC.7010809@mailnetwork.co.uk>
References: <BAY131-F2264ABE55640D3989C26DAB0780@phx.gbl>
<45F1A4CC.7010809@mailnetwork.co.uk>
http://www.postgresql.org/docs/8.2/interactive/app-postgres.html
On Fri, 2007-03-09 at 18:17 +0000, Andy Shellam wrote:
> Remove other users' entries in pg_hba.conf so it only allows your
> username from your machine.
>
> Andy.
>
> 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
> >
> > _________________________________________________________________
> > Get a FREE Web site, company branded e-mail and more from Microsoft
> > Office Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
> >
> > !DSPAM:37,45f1a140103006986215648!
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bnichols@ca.afilias.info, andy.shellam-lists@mailnetwork.co.uk, skarthi98@hotmail.com, pgsql-admin@postgresql.org
Subject: Re: Running in single instance mode
In-Reply-To: <1173466872.5446.2.camel@dba5.int.libertyrms.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