Thread: Difficulties Connecting on localhost

Hi, I am running Red Hat Linux, ES (Enterprise) 3.0. Just got done
successfully installing PostgreSQL v 8.1.2 yesterday.

I am trying to install pgAdmin3, version 1.2.0. The only one that I could
get to install was a 386 version for RedHat9. It appeared to install fine,
and is up and running, but I can't get it to connect to the database. The
error being given is an authentication error; but the authentication
information I am giving works fine when I use it to log into the psql
command line tool.

Can anyone tell me what is wrong here, and how to fix (please be very
specific) ?

Lane Van Ingen wrote:
> Hi, I am running Red Hat Linux, ES (Enterprise) 3.0. Just got done
> successfully installing PostgreSQL v 8.1.2 yesterday.
>
> I am trying to install pgAdmin3, version 1.2.0. 

You need 1.4.x for PostgreSQL 8.1 support.
> The only one that I could
> get to install was a 386 version for RedHat9. It appeared to install fine,
> and is up and running, but I can't get it to connect to the database. The
> error being given is an authentication error; but the authentication
> information I am giving works fine when I use it to log into the psql
> command line tool.
>
> Can anyone tell me what is wrong here, and how to fix (please be very
> specific) ?
>   
Use 1.4.x, it includes additional aid.

Regards,
Andreas

Thanks for your suggestions.

I  followed through on suggestions below, but I am having a lot of problems.

Probably the basic problem is that I have RedHat ES (Enterprise) 3.0, and
the nearest I can find on www.postgres.org for pgAdmin3 is a Fedora version;
it keeps asking me for more and more libraries as I try to install the rpm.
That is part of the reason I tried to install an older version of pgAdmin,
as I was hoping to avoid a lot of new requirements that might not be
supported
on an older (2 yrs old?) Linux server.

If I drop back from PostgreSQL v 8.1.2 to 8.0.7, will pgAdmin 1.2 work with
it?

Any other suggestions?

-----Original Message-----
From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
Sent: Thursday, March 02, 2006 12:19 PM
To: Lane Van Ingen
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Difficulties Connecting on localhost


Lane Van Ingen wrote:
> Hi, I am running Red Hat Linux, ES (Enterprise) 3.0. Just got done
> successfully installing PostgreSQL v 8.1.2 yesterday.
>
> I am trying to install pgAdmin3, version 1.2.0.

You need 1.4.x for PostgreSQL 8.1 support.
> The only one that I could
> get to install was a 386 version for RedHat9. It appeared to install fine,
> and is up and running, but I can't get it to connect to the database. The
> error being given is an authentication error; but the authentication
> information I am giving works fine when I use it to log into the psql
> command line tool.
>
> Can anyone tell me what is wrong here, and how to fix (please be very
> specific) ?
>
Use 1.4.x, it includes additional aid.

Regards,
Andreas

Lane Van Ingen wrote:
> Thanks for your suggestions.
>
> I  followed through on suggestions below, but I am having a lot of problems.
>
> Probably the basic problem is that I have RedHat ES (Enterprise) 3.0, and
> the nearest I can find on www.postgres.org for pgAdmin3 is a Fedora version;
> it keeps asking me for more and more libraries as I try to install the rpm.
> That is part of the reason I tried to install an older version of pgAdmin,
> as I was hoping to avoid a lot of new requirements that might not be
> supported
> on an older (2 yrs old?) Linux server.
>
> If I drop back from PostgreSQL v 8.1.2 to 8.0.7, will pgAdmin 1.2 work with
> it?
>   
Yes, but I certainly won't recommend downgrading (while pgsql backports 
fixes, we don't because pgAdmin is always backward compatible).
I'd suggest building the latest pgAdmin from source.

Regards,
Andreas