Asking for password at startup - Mailing list pgsql-general

From Andrew
Subject Asking for password at startup
Date
Msg-id 20021206170115.C8412-100000@starbug.ugh.net.au
Whole thread Raw
List pgsql-general
Hi,

If I don't have the line:

local all trust

in my pg_hba.conf file then postgresSQL asks for a password on startup.
Clearly it is trying to connect to a database but I can't find which one.

My desired options (if they were to work) are:

local sameuser trust
local all trust admins
local all md5
host all 127.0.0.1 255.255.255.255 md5

I understand there is a problem with specifying the local all md5 line as
any search will match the earlier line so I'm after advise on how to
acheive such as result.

Thanks,

Andrew



pgsql-general by date:

Previous
From: Jeremiah Jahn
Date:
Subject: pg_dump 2 gig file size limit on ext3
Next
From: "annachau"
Date:
Subject: Can I User @@error of MS SQL in postgresql