Skip site navigation (1) Skip section navigation (2)

Re: basic security

From: Tim Bowden <tim(dot)bowden(at)westnet(dot)com(dot)au>
To: reh2(at)prodigy(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: basic security
Date: 2008-11-05 17:51:08
Message-ID: 1225907468.6076.17.camel@edoras (view raw or flat)
Thread:
Lists: pgsql-novice
See pg_hba.conf.

http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html

Regards,
Tim Bowden

On Wed, 2008-11-05 at 09:34 -0800, Robert Hollingsworth wrote:
> hello,
> I want to establish basic security for my pgsql database, which is on
> a commercial web server.  In particular, I don't want people to be
> able to login from the internet as my superuser.
> 
> If I ALTER USER my_superuser NOLOGIN, will that be sufficient?  I've
> passworded that user, but I seem to be able to get access myself
> without providing the password.
> 
> thanks,
> REH
> 
-- 
Experience is that marvelous thing that enables you recognize a mistake
when you make it again.


In response to

pgsql-novice by date

Next:From: Gabriele MessineoDate: 2008-11-06 08:38:10
Subject: how to avoid deadlocks?
Previous:From: Robert HollingsworthDate: 2008-11-05 17:34:33
Subject: basic security

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group