Обсуждение: Running in single instance mode
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/
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! > >
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
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.