-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 devonerik@shalebridge:~$ /usr/lib/postgresql/9.3/bin/postgres -V postgres (PostgreSQL) 9.3.2 devonerik@shalebridge:~$ pgadmin3 -v pgAdmin III 1.18.1
devonerik@shalebridge:~$ psql -U postgres -W Password for user postgres: psql (9.3.2) Type "help" for help. postgres=# select * from pg_user postgres-# ; usename | usesysid | usecreatedb | usesuper | usecatupd | userepl | passwd | valuntil | useconfig - ----------+----------+-------------+----------+-----------+---------+----------+----------+----------- postgres | 10 | t | t | t | t | ******** | infinity | (1 row) postgres=# \q devonerik@shalebridge:~$ devonerik@shalebridge:~$ sudo cat /etc/postgresql/9.3/main/pg_hba.conf | grep -v '\#' local all postgres md5 local all all md5 host all all 127.0.0.1/32 md5 host all all ::1/128 md5 Given all this, PGadmin silently fails to connect to the server with no error message, simply a repeat of the prompt for server info. The password IS correct, I just authenticated through psql with it. Changing any or all of the lines in pg_hba.conf from md5, to peer, to trust, and restarting the server does nothing. PGadmin connect attempts create no entries in /var/log/postgresql/postgresql-9.3-main.log. There are some Purging and reinstalling PGadmin has no effect. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJS4D1SAAoJEAy07rHw4yiv4xMIAKFfkqweZCxkYBjKO9EhvTBy eRlXQQIC4yPGbwPks1zfuaVEAzwu9PsgPgqWRvXseHWZXdWONMMXrYe15TzUXgY6 zR7jBdp3sl25COJbZRFtziR213UloKIajOGDffaU73/qCUI74XuGrIJAVIwqCOYv eDT07c1qiac8WCAXQ+Qix5YIjUaU0VqdB8BF+ihTheB/6GdD+ZF3H3/8lYakc4Fg xJy5x4/3NyQgyEPeAGGhHyX2+MjiOLJ5zK66c1J0WOsc27Ib/PutQFSntVFflaeJ Q07wo6+R5q5DjAKAmsCQe5hGkr1Svy30revAzvB8h1dLqMYIjjT1JumyfPvts/I= =XW2d -----END PGP SIGNATURE----- -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
