Skip site navigation (1) Skip section navigation (2)

Error connecting for first connect upon pgAdmin start (with solution)

From: Martin Schayna <mschayna(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Error connecting for first connect upon pgAdmin start (with solution)
Date: 2011-03-03 16:12:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Small bug + solution

pgAdmin III 1.12.0
PostgreSQL 9.0
Ubuntu Linux 10.04
installed completely from Martin Pitt's PPA, but also
reproducible with original Ubuntu repositories (PostgreSQL 8.4,
pgAdmin III 1.10.2)


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


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


pgadmin-support by date

Next:From: Boblitz JohnDate: 2011-03-04 06:54:32
Subject: pgadminIII Configuration problem
Previous:From: Ashesh VashiDate: 2011-03-03 04:27:14
Subject: Re: paste into SQL editor from Eclipse on Mac doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group