I have installed a pgsql (8.1) on my computer (windows xp + apache 2) and there is a problem while trying to connect ta a database server. I use pgadmin3 and when I hit "connect" my computer "thiks" for a 3-5minutes and then a windows style popup with text like this:

"Server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request".

Firewall off, apache listens on port 5432, all configured to connect with localhost.

Does anyone have any idea what to do?

On 9/4/06, Krzysztof Bienias <k.bienias@poczta.fm> wrote:

> Firewall off, apache listens on port 5432, all configured to connect with localhost.
>
> Does anyone have any idea what to do?
Why would apache be listening on 5432? Or why would pgAdmin
know how to talk apache?


Cheers,
Andrej

P.S.: Please don't use HTML or other fancy stuff for mailing-lists

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Krzysztof Bienias wrote:
> I have installed a pgsql (8.1) on my computer (windows xp + apache 2)
> and there is a problem while trying to connect ta a database server. I
> use pgadmin3 and when I hit "connect" my computer "thiks" for a
> 3-5minutes and then a windows style popup with text like this:
>
> "Server closed the connection unexpectedly
> This probably means the server terminated abnormally before or while
> processing the request".
>
> Firewall off, apache listens on port 5432, all configured to connect
> with localhost.
>
> Does anyone have any idea what to do?
>


Looking at your server log is probably a good place to start, but other
than that, I'm not sure what the most common cause of this error is.

Sean

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

am Mon, dem 04.09.2006, um 19:16:59 -0400 mailte Sean Davis folgendes:
> Krzysztof Bienias wrote:
> >I have installed a pgsql (8.1) on my computer (windows xp + apache 2)
> >and there is a problem while trying to connect ta a database server. I
> >use pgadmin3 and when I hit "connect" my computer "thiks" for a
> >3-5minutes and then a windows style popup with text like this:
> >
> > "Server closed the connection unexpectedly
> >This probably means the server terminated abnormally before or while
> >processing the request".
> >
> >Firewall off, apache listens on port 5432, all configured to connect
> >with localhost.

Apache listens on port 5432?


Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--- Krzysztof Bienias <k.bienias@poczta.fm> wrote:

> I have installed a pgsql (8.1) on my computer
> (windows xp + apache 2) and there is a problem while
> trying to connect ta a database server. I use
> pgadmin3 and when I hit "connect" my computer
> "thiks" for a 3-5minutes and then a windows style
> popup with text like this:
>
> "Server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request".
>
> Firewall off, apache listens on port 5432, all
> configured to connect with localhost.
>
> Does anyone have any idea what to do?
>

Following these instructions should get the job done.
You can review them in order to find any deviation you
may have taken and correct it. there is no shame in
starting over from scratch.

if you knew how many times i started from scratch
while installin gpgsql over cygwin, you'd be stunned.

i'm still stunned 2 years later.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match