Re: Postgresql / ident?

["M Lubratt" <..hidden..>]

You first need to create the ledgersmb role first and allow it to create databases.  Something like:

$ createuser -Upgsql -d -P ledgersmb

HTH!
Mark

On 5/1/07, Antony Gelberg <..hidden..> wrote:

Hi,

Trying to install for the first time, reading the INSTALL file.

$ createdb -U ledgersmb -O ledgersmb ledgersmb
createdb: could not connect to database postgres: FATAL:  Ident
authentication failed for user "ledgersmb"

With sql-ledger, I used to have something like:

local   <dbname>        <username>              trust

in pg_hba.conf.  So I added:

local   ledgersmb       ledgersmb               trust

and restarted postgresql, but the same happened.

Do I need to install identd?  I thought identd went out of fashion years
ago.  What do I need to add to pg_hba.conf?

Antony


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users