postgres authentication question

From: Tom Allison <tallison(at)tacocat(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: postgres authentication question
Date: 2006-11-18 14:36:58
Message-ID: 455F1A8A.3030902@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

By default my installation via Debian set the user postgres to authenticate as a
local, ident sameuser.

This is convenient for someone with a local account.

I'm putting a postgresql installation into my DMZ and want to make sure I have
an understanding of what makes sense and what does not in terms of security.

I would like to change the postgres user to authenticate by md5 only, no ident
sameuser option. I might still keep the authentication as local only. But when
I do this, at start up I get a number of minor errors in my logs about the user
postgres can't authenticate.

How do I fix this securely?
-or-
How do I safely disable this?
-or-
Is this a non-problem and should be ignored?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Allison 2006-11-18 14:39:59 Re: methodology tuning
Previous Message Phillip Smith 2006-11-16 20:37:55 Re: numeric data type