Обсуждение: New laptop install - pgadmin not remembering password and not showing jobs tree menu

Hi all,

I just completely re-installed my laptop with Windows XP.  After I
re-installed my laptop pgadmin still seems to be operating
incorrectly.  I posted a thread awhile back
(http://www.pgadmin.org/archives/pgadmin-support/2005-12/msg00003.php)
with an issue that pgadmin 1.4 wasn't remembing the password on my
computer.  A few people posted similar issues and I (personally) never
got it resolved.  I was hoping this laptop re-install would clear up
any problems.

Alas I still suffer from the same problem and as it is a fresh new
install of XP I really don't understand how this can be.  Is it
possible that some existing software I have is wrecking something?
Also, pgadmin is not showing me the 'jobs' tree item after I installed
pgagent.  So I use the exact same setup on another desktop computer
and it both remembers passwords and shows me the jobs tree.

-Windows XP SP2
-pgadmin 1.4.2
-Postgresql 8.1 (running on a debian linux box, connecting through ssh tunnel)
-%APPDATA%\postgresql\pgpass.conf contents http://mcrt.ca/~cpeters/pgpass.jpg
-Only libpq.dll on computer in "C:\Program Files\pgAdmin III\1.4" with
file version 8.1.3.6044

I am more concerned about the jobs tree menu item not showing up than
the password but would like to get both fixed.

Regards,
Collin

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Collin Peters
> Sent: 27 March 2006 22:40
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] New laptop install - pgadmin not
> remembering password and not showing jobs tree menu
>
> Hi all,
>
> I just completely re-installed my laptop with Windows XP.  After I
> re-installed my laptop pgadmin still seems to be operating
> incorrectly.  I posted a thread awhile back
> (http://www.pgadmin.org/archives/pgadmin-support/2005-12/msg00003.php)
> with an issue that pgadmin 1.4 wasn't remembing the password on my
> computer.  A few people posted similar issues and I (personally) never
> got it resolved.  I was hoping this laptop re-install would clear up
> any problems.
>
> Alas I still suffer from the same problem and as it is a fresh new
> install of XP I really don't understand how this can be.  Is it
> possible that some existing software I have is wrecking something?
> Also, pgadmin is not showing me the 'jobs' tree item after I installed
> pgagent.  So I use the exact same setup on another desktop computer
> and it both remembers passwords and shows me the jobs tree.
>
> -Windows XP SP2
> -pgadmin 1.4.2
> -Postgresql 8.1 (running on a debian linux box, connecting
> through ssh tunnel)
> -%APPDATA%\postgresql\pgpass.conf contents
> http://mcrt.ca/~cpeters/pgpass.jpg
> -Only libpq.dll on computer in "C:\Program Files\pgAdmin III\1.4" with
> file version 8.1.3.6044
>
> I am more concerned about the jobs tree menu item not showing up than
> the password but would like to get both fixed.

The tree problem is most likely caused by using the wrong database as
the maintenance DB in your connection. Perhaps on one machine you chose
template1 instead of postgres?

The password problem might be caused by accessing the database as
localhost instead of 127.0.0.1 which is in your pgpass.conf file - could
that be the case?

Regards, Dave.

Turns out it was installed into the wrong database.  So I'm not sure
why it showed up before on another computer in pgadmin but not this
one, but re-installing it into the postgres database seems to have
done it.

I also found out the other day that pgadmin doesn't remember the
password if you use 127.0.0.1, localhost must be used instead

On 3/29/06, Dave Page <dpage@vale-housing.co.uk> wrote:
>
>
> > -----Original Message-----
> > From: pgadmin-support-owner@postgresql.org
> > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> > Collin Peters
> > Sent: 27 March 2006 22:40
> > To: pgadmin-support@postgresql.org
> > Subject: [pgadmin-support] New laptop install - pgadmin not
> > remembering password and not showing jobs tree menu
> >
> > Hi all,
> >
> > I just completely re-installed my laptop with Windows XP.  After I
> > re-installed my laptop pgadmin still seems to be operating
> > incorrectly.  I posted a thread awhile back
> > (http://www.pgadmin.org/archives/pgadmin-support/2005-12/msg00003.php)
> > with an issue that pgadmin 1.4 wasn't remembing the password on my
> > computer.  A few people posted similar issues and I (personally) never
> > got it resolved.  I was hoping this laptop re-install would clear up
> > any problems.
> >
> > Alas I still suffer from the same problem and as it is a fresh new
> > install of XP I really don't understand how this can be.  Is it
> > possible that some existing software I have is wrecking something?
> > Also, pgadmin is not showing me the 'jobs' tree item after I installed
> > pgagent.  So I use the exact same setup on another desktop computer
> > and it both remembers passwords and shows me the jobs tree.
> >
> > -Windows XP SP2
> > -pgadmin 1.4.2
> > -Postgresql 8.1 (running on a debian linux box, connecting
> > through ssh tunnel)
> > -%APPDATA%\postgresql\pgpass.conf contents
> > http://mcrt.ca/~cpeters/pgpass.jpg
> > -Only libpq.dll on computer in "C:\Program Files\pgAdmin III\1.4" with
> > file version 8.1.3.6044
> >
> > I am more concerned about the jobs tree menu item not showing up than
> > the password but would like to get both fixed.
>
> The tree problem is most likely caused by using the wrong database as
> the maintenance DB in your connection. Perhaps on one machine you chose
> template1 instead of postgres?
>
> The password problem might be caused by accessing the database as
> localhost instead of 127.0.0.1 which is in your pgpass.conf file - could
> that be the case?
>
> Regards, Dave.
>