Small bug + solution
pgAdmin III 1.12.0
PostgreSQL 9.0
Ubuntu Linux 10.04
installed completely from Martin Pitt's PPA
https://launchpad.net/~pitti/+archive/postgresql, but also
reproducible with original Ubuntu repositories (PostgreSQL 8.4,
pgAdmin III 1.10.2)
Scenario:
1) start pgAdmin from console: $ pgadmin3
2) warning appears on console: WARNING: password file "/home/mase/.pgpass" has group or world
access; permissions should be u=rw (0600) or less
3) now try to connect some server by double-clicking server node in
tree, error window appears and server is not connected: An error has occurred: Error connecting to the server:
fe_sendauth:no password supplied
4) subsequent tries works, until pgAdmin close
Solution:
When I change permissions for .pgpass file as warning suggested,
connection error for first connect upon pgAdmin start disappears and
everything works like a charm. It looks like there is some lack in
reading passwords from .pgpass when warning is shown.
Keep up good work, guys!
Martin Schayna