| From: | Andy Shellam <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk> |
|---|---|
| To: | Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Running in single instance mode |
| Date: | 2007-03-09 18:17:48 |
| Message-ID: | 45F1A4CC.7010809@mailnetwork.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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!
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo De León | 2007-03-09 18:58:36 | Re: [SQL] Running in single instance mode |
| Previous Message | Karthikeyan Sundaram | 2007-03-09 18:00:53 | Running in single instance mode |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2007-03-09 18:32:20 | Re: [SQL] PostgreSQL to Oracle |
| Previous Message | Ezequias Rodrigues da Rocha | 2007-03-09 18:07:31 | Re: Statistics |