Thread: SOLUTION : pgsql 7.2 on Cygwin PGSTAT : Connection(2) refused error message after postmaster starting

Jason, & list members,

Well I have solved the problem of the PGSTAT : Connection refused error.

ZoneAlarm

After going round the houses attempting to sus-out the problem, I suddenly
had a momentary lapse of reason and thought that Zonealarm could be
affecting things.

I of course registered postmaster, postgres.exe and psql.exe as programs to
allow traffic, when I first installed 7.1.3 postgresql in cygwin 1.3.9.

For some reason, unexplainable to me, the settings inside Zonealarm must
have got confused because they were now working against me. I went to the
Programs list and removed the entries from zone alarm, and then tried
starting the postmaster (the point at which I had been getting the PGSTAT
Connection refused message many times in the last few days) and ... IT
WORKED!!!

Of course Zonealarm asked me'do you want to allow postmaster to ....' and I
duly responded. They are now all back in the list in Zone Alarm and no
longer complaining....

So, for anyone reading this, or searching the archives and reading this,
CHECK YOUR FIREWALL!

May it be pertinent to add a line in the docs that go with the builds of
Pgsql in cygwin to say something similar?

Many many thanks to Jason on this list for all his help in solving this
trouble. Despite the fact it was nothing to do with pgsql or cygwin, its
nice to know someone could hear my cries. The process of attempting to fix
it has of course been a real learning experience and now I understand much
more about cygwin, pgsql installs etc. etc.

I suppose, I could have always turned my red hat box back on but that would
have been cheating now wouldn't it!!

Tim Finch,
FosterFinch Ltd
http://www.fosterfinch.co.uk

Tim,

On Wed, Mar 06, 2002 at 10:28:50AM +0000, Tim Finch, FosterFinch Ltd wrote:
> Well I have solved the problem of the PGSTAT : Connection refused error.
>
> ZoneAlarm

Time to buy a "real" firewall, as in hardware? :,)

> May it be pertinent to add a line in the docs that go with the builds of
> Pgsql in cygwin to say something similar?

Post a patch to /usr/doc/Cygwin/postgresql-7.2.README here and I will
include it in the next iteration.

> Many many thanks to Jason on this list for all his help in solving this
> trouble. Despite the fact it was nothing to do with pgsql or cygwin, its
> nice to know someone could hear my cries.

You are welcome.

> The process of attempting to fix
> it has of course been a real learning experience and now I understand much
> more about cygwin, pgsql installs etc. etc.

Although painful, the above is generally true -- at least in my
experience.

Jason

At 08:51 06/03/2002 -0500, Jason Tishler wrote:
>Tim,
>
>On Wed, Mar 06, 2002 at 10:28:50AM +0000, Tim Finch, FosterFinch Ltd wrote:
> > Well I have solved the problem of the PGSTAT : Connection refused error.
> >
> > ZoneAlarm
>
>Time to buy a "real" firewall, as in hardware? :,)

Well... as I work almost exclusively on my laptop, with at present a dial
up modem, it would be a bit of a burden to cart round everywhere!! But
point taken.

> > May it be pertinent to add a line in the docs that go with the builds of
> > Pgsql in cygwin to say something similar?
>
>Post a patch to /usr/doc/Cygwin/postgresql-7.2.README here and I will
>include it in the next iteration.

OK, will look at it. When you say patch I guess you mean type something
into an email for you to append manually, or are you talking Diff files here?


> > The process of attempting to fix
> > it has of course been a real learning experience and now I understand much
> > more about cygwin, pgsql installs etc. etc.
>
>Although painful, the above is generally true -- at least in my
>experience.

Well yes, I suppose my entire IT career has been built on the iterative
process of

- I fancy getting into this
- ARRRGGHH
- Oh I see
- Here's the invoice for teaching you something I learnt earlier (at home,
alone, in pain)

Tim.

Tim,

On Wed, Mar 06, 2002 at 10:22:32PM +0000, Tim Finch wrote:
> At 08:51 06/03/2002 -0500, Jason Tishler wrote:
> >Post a patch to /usr/doc/Cygwin/postgresql-7.2.README here and I will
> >include it in the next iteration.
>
> OK, will look at it. When you say patch I guess you mean type something
> into an email for you to append manually, or are you talking Diff files
> here?

Yes, I meant diff.  For example:

    $ diff -u postgresql-7.2.README.orig postgresql-7.2.README >postgresql-7.2.README.diff

Please post with postgresql-7.2.README.diff attached (as opposed to
inline) to prevent patch corruption by dumb mailers.

Thanks,
Jason