Re: SOLUTION : pgsql 7.2 on Cygwin PGSTAT : Connection(2)

От:

Jason Tishler <jason@tishler.net>

Дата:

6 марта 2002 г. в 08:47:18

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

Re: SOLUTION : pgsql 7.2 on Cygwin PGSTAT : Connection(2)

От:

Jason Tishler <jason@tishler.net>

Дата:

7 марта 2002 г. в 07:43:55

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

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

От:

"Tim Finch, FosterFinch Ltd" <tim@fosterfinch.co.uk>

Дата:

6 марта 2002 г. в 05:34:37

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

Re: SOLUTION : pgsql 7.2 on Cygwin PGSTAT :

От:

Tim Finch <pgadmin@timfinch.cix.co.uk>

Дата:

6 марта 2002 г. в 17:26:31

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.