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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gabriele Messineo | 2008-11-06 08:38:10 | how to avoid deadlocks? |
Previous Message | Robert Hollingsworth | 2008-11-05 17:34:33 | basic security |