Thread: Error in pgAdmin II

Hi,

I downloaded pgAdmin II yesterday and installed it on my desktop,
but when i try to connect to my PostGresSQL database on RedHat Linux 7
I got this errror message:

    Error in pgAdmin II:frmConnect.cmdConnect_Click: -2147467259 -
        Could not connect to the server; Could not connect to remote socket.

        Note: I successfully installed pgAdmin II and all of its

              requirements/prerequisites on my pc and the postmaster is up
and
              running on RedHat Linux 7.

              Although I'm not so sure if i had configured the postmaster or

              PostGresSQL properly --- I just started using PostGresSQL last

              week.

             I included a this line in the pg_hba.conf:

                     host  all  my.pc's.ip.address  255.255.255.0  trust

             Do I need to restart postmaster in order for this to take
effect?
             More important, would this solve my problem?

             Please explain the line below (as of now, the line below is not

             included in my pg_hba.conf or is tag as commnet with "#"):

                    host  all  0.0.0.0   0.0.0.0  trust

             Do I need to inlude this in my pg_hba.conf? If my understanding
is
             correct this would allow anybody (any pc/host) to connect
             to postamaster and use any database. Please correct me if I'm

             wrong. If I'm right do I need my to restart postmaster? Would
             this solve my problem?


Hope you could give me some advice asap, I'm tired of doing everything via
CLI.
My expectation with pgAdmin II is that I could administer my PostGresSQL
database on Linux at my desktop pc and that it would be via GUI (coz i'm the
VisualBoy) like the enterprise manager of MS-SQL Server or the Sybase
Central of ASE.

Thanks and more power.


VisualBoy






_______________________________________________________
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/

> -----Original Message-----
> From: VisualBoy@excite.com [mailto:VisualBoy@excite.com]
> Sent: 19 September 2001 01:14
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Error in pgAdmin II
>
>
>
> Hi,
>
> I downloaded pgAdmin II yesterday and installed it on my desktop,
> but when i try to connect to my PostGresSQL database on
> RedHat Linux 7 I got this errror message:
>
>     Error in pgAdmin II:frmConnect.cmdConnect_Click: -2147467259 -
>         Could not connect to the server; Could not connect to
> remote socket.

<snip>

Hi,

There are a number of things to check to fix this error:

1) Can you ping the server from the workstation. If so, then your network is
OK, if not then you will need to sort that out.
2) Is PostgreSQL running and accepting tcp/ip connections? Make sure that
the postmaster is started with the -I option to enable this.
3) Check the host & port number on the pgAdmin II login dialogue. The port
defaults to 5432 (as does PostgreSQL), but if you've specified something
else on the server then you must specify it here as well.

>
> Hope you could give me some advice asap, I'm tired of doing
> everything via CLI. My expectation with pgAdmin II is that I
> could administer my PostGresSQL database on Linux at my
> desktop pc and that it would be via GUI (coz i'm the
> VisualBoy) like the enterprise manager of MS-SQL Server or
> the Sybase Central of ASE.

Sound's like pgAdmin II is exactly the tool you want!

Let me know how you get on,

Regards, Dave.