I installed / uninstalled pgadmin 3 twice via synaptic, finally grabbed
the package via apt-get install pgadmin3. Not hanging up now, but
simply getting an authentication error in a pop up window:

an error has occured:

Error connecting to the server: FATAL: IDENT authentication
occured for user "myusername"

The same username/password gets me into the database just fine
via command line psql.


Via the dpkg command I see:
root@PhiLinux:/home/fractalvibes # dpkg -l pgadmin3
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err:
uppercase=bad)
||/ Name Version Description
+++-==============-==============-============================================
ii pgadmin3 1.2.0-1 Graphical administration tool for
PostgreSQL
root@PhiLinux:/home/fractalvibes #

Not sure what kind of config problem I have here....???

Phil J.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

> 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).
If you're running Debian Stable, you need to use custom built .deb files.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly