-----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-----