Thread: Problem with the Connection

Problem with the Connection

From
"Matze"
Date:
Hallo There,

I've got a Problem with PostgreSQL. I installed the Windows Binary of
Postgre 8.1 (postgresql-8.1.msi). During the Installation the Installer
popped up several messages that some Propertys of the Server or the Tables
couldn't be set correctly. But the Installer itself finished the
installation sucessfully.

When I try to connect pgAdmin III with the running Postgre Server (on
localhost) I get the followin message:
------------------------------------
psql: server closed the connection unexpectedly.This probably means the
server terminated abnormally before or while processing the request.
------------------------------------
The same message appears in the console when I try to connect via the
console.

I hope somebody can help me.



Matthias Feist

(Sorry for the bad English)


Re: Problem with the Connection

From
"Jim C. Nasby"
Date:
On Thu, Mar 16, 2006 at 08:34:19PM +0100, Matze wrote:
> Hallo There,
>
> I've got a Problem with PostgreSQL. I installed the Windows Binary of
> Postgre 8.1 (postgresql-8.1.msi). During the Installation the Installer
> popped up several messages that some Propertys of the Server or the Tables
> couldn't be set correctly. But the Installer itself finished the
> installation sucessfully.

Kinda difficult to debug without exact error messages. :(

> When I try to connect pgAdmin III with the running Postgre Server (on
> localhost) I get the followin message:
> ------------------------------------
> psql: server closed the connection unexpectedly.This probably means the
> server terminated abnormally before or while processing the request.
> ------------------------------------
> The same message appears in the console when I try to connect via the
> console.

What's the uncommented lines in pg_hba.conf say? Can you connect to port
5432 on localhost with telnet?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461