From: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
To: Karthikeyan Sundaram <skarthi98@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Running in single instance mode
Date: Fri, 09 Mar 2007 18:17:48 +0000
Message-ID: <45F1A4CC.7010809@mailnetwork.co.uk> (raw)
In-Reply-To: <BAY131-F2264ABE55640D3989C26DAB0780@phx.gbl>
References: <BAY131-F2264ABE55640D3989C26DAB0780@phx.gbl>
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!
>
>
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: andy.shellam-lists@mailnetwork.co.uk, skarthi98@hotmail.com, pgsql-admin@postgresql.org
Subject: Re: Running in single instance mode
In-Reply-To: <45F1A4CC.7010809@mailnetwork.co.uk>
* 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