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

basic security

From: Robert Hollingsworth <reh2(at)prodigy(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: basic security
Date: 2008-11-05 17:34:33
Message-ID: 988156.71865.qm@web80505.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Tim BowdenDate: 2008-11-05 17:51:08
Subject: Re: basic security
Previous:From: Tom LaneDate: 2008-11-05 15:42:10
Subject: Re: viewing currently executing query

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