Re: Running in single instance mode

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk
Cc: Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Running in single instance mode
Date: 2007-03-09 19:01:11
Message-ID: 1173466872.5446.2.camel@dba5.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Glen W. Mabey 2007-03-09 19:11:12 Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist
Previous Message Rodrigo De León 2007-03-09 18:58:36 Re: [SQL] Running in single instance mode

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2007-03-09 19:32:12 Re: [SQL] PostgreSQL to Oracle
Previous Message Rodrigo De León 2007-03-09 18:58:36 Re: [SQL] Running in single instance mode