| 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 |