Re: opening postgresql first time

Поиск
Список
Период
Сортировка
От joseph speigle
Тема Re: opening postgresql first time
Дата
Msg-id 20040428022444.GA10341@www.sirfsup.com
обсуждение исходный текст
Ответ на opening postgresql first time  (Robert Morgan <robert_@ihug.co.nz>)
Список pgsql-novice
Bob,

the sameuser special map is shown in the pg_hba.conf above (see its last line which says:
local all ident sameuser
)
In other words, sameuser says that the os username must match the postgres username. It is a special ident map. If it's
includedin pg_hba.conf then it will preclude ident.conf from ever being checked.  

pg_ident.conf allows mapping from one user to another user, from system user to postgresql user.

try just deleting that line from pg_hba.conf and SIGHUPPing  i:)



On Wed, Apr 28, 2004 at 01:56:53PM +1200, Robert Morgan wrote:
> Hi have just installed postgres and tried to open it using: psql
> template1 postgres
> and get an error ident authentication failed.
>
> How do I open the dbms to add a user?
> Can I do it from the shell?
>
> Bob
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
joe speigle
www.sirfsup.com

В списке pgsql-novice по дате отправления:

Предыдущее
От: Daniel Whelan
Дата:
Сообщение: How to retrieve the serial number of an INSERT?
Следующее
От: Avi Schwartz
Дата:
Сообщение: Re: opening postgresql first time