pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRunning in single instance mode
4+ messages / 4 participants
[nested] [flat]
* Running in single instance mode
@ 2007-03-09 18:00 Karthikeyan Sundaram <skarthi98@hotmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Karthikeyan Sundaram @ 2007-03-09 18:00 UTC (permalink / raw)
To: pgsql-sql; pgsql-admin@postgresql.org
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Running in single instance mode
@ 2007-03-09 18:17 Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
parent: Karthikeyan Sundaram <skarthi98@hotmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Andy Shellam @ 2007-03-09 18:17 UTC (permalink / raw)
To: Karthikeyan Sundaram <skarthi98@hotmail.com>; +Cc: pgsql-admin@postgresql.org
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!
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] Running in single instance mode
@ 2007-03-09 18:58 Rodrigo De León <rdeleonp@gmail.com>
parent: Karthikeyan Sundaram <skarthi98@hotmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Rodrigo De León @ 2007-03-09 18:58 UTC (permalink / raw)
To: pgsql-sql; pgsql-admin@postgresql.org
On 3/9/07, Karthikeyan Sundaram <skarthi98@hotmail.com> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Running in single instance mode
@ 2007-03-09 19:01 Brad Nicholson <bnichols@ca.afilias.info>
parent: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Brad Nicholson @ 2007-03-09 19:01 UTC (permalink / raw)
To: andy.shellam-lists@mailnetwork.co.uk; +Cc: Karthikeyan Sundaram <skarthi98@hotmail.com>; pgsql-admin@postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-03-09 19:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-09 18:00 Running in single instance mode Karthikeyan Sundaram <skarthi98@hotmail.com>
2007-03-09 18:17 ` Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
2007-03-09 19:01 ` Brad Nicholson <bnichols@ca.afilias.info>
2007-03-09 18:58 ` Rodrigo De León <rdeleonp@gmail.com>
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