Re: Error in pgAdmin II

> -----Original Message-----
> From: VisualBoy(at)excite(dot)com [mailto:VisualBoy(at)excite(dot)com]
> Sent: 19 September 2001 01:14
> To: pgadmin-support(at)postgresql(dot)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.