Re: connect/install problems - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: connect/install problems
Date
Msg-id 430EE8DA.9030905@pse-consulting.de
Whole thread Raw
In response to Re: connect/install problems  (Alex Perry <alex.perry@ieee.org>)
List pgadmin-support
Alex Perry wrote:
>>an error has occured:
>>
>>Error connecting to the server: FATAL: IDENT authentication
>>occured for user "myusername"
> 
> 
> That's because PSQL by default uses a unix socket and your previous
> email showed you were using a network socket for PGADMIN.  Which is
> fine, except that the latter has to use the IDENT network service
> to figure out who you are.  If PSQL is working and PGADMIN is not,
> I would suspect that you don't have a working identd running yet.
> 
> Either install one, eg
>     apt-get install pidentd
> or tell pgadmin3 to use a unix socket (see list archives under my name).

Unix sockets are not supported in 1.2; will be in 1.4. Edit 
postgresql.conf to use md5 instead of ident solves this too.

Regards,
Andreas


pgadmin-support by date:

Previous
From: Alex Perry
Date:
Subject: Re: connect/install problems
Next
From: "Michael Schmidt"
Date:
Subject: boolean field default value