Thread: Can't connect to server (postgresql6.2.1)

Can't connect to server (postgresql6.2.1)

From
Stefan Mertl
Date:
A software package i want to use requires postgresql version 6.2.1
Therefor i compiled and installed it, everything works fine. I can
connect to the server via psql in xterm.
But the software claims, that there is no postgre server running.
My hd_dba.conf has the correct settings:
   host        all     127.0.0.1        255.255.255.255

The man pages say, that there is the -i option to allow access via
tcp/ip, but if i'm trying to start postmaster -i it prompts me the
help message with the different options. And there no -i option is
mentioned.
Did i forget to set an option while configuring or compiling?



Re: Can't connect to server (postgresql6.2.1)

From
Tom Lane
Date:
Stefan Mertl <zongo@gmx.at> writes:
> A software package i want to use requires postgresql version 6.2.1

"Requires"?  Have you tried getting it to play with something a little
less hoary?  Certainly we haven't been perfect about maintaining
backwards compatibility, but we try not to break things.  I'd really
recommend trying to use a recent version instead --- the number of bugs
fixed since 6.2.1 is large.

> The man pages say, that there is the -i option to allow access via
> tcp/ip, but if i'm trying to start postmaster -i it prompts me the
> help message with the different options. And there no -i option is
> mentioned.

Looking at the release history, it seems that the -i switch was added
at release 6.3, and the format of pg_hba.conf changed at the same time.
You'd better consult the documentation that goes with 6.2.1, not newer
docs.

            regards, tom lane