Re: Postgres 7.1-2 repeatedly fails to connect

Richard,

On Mon, Apr 30, 2001 at 01:23:46AM -0000, Richard Church wrote:
> Question 1
>
> I am able to install and initdb Postgres. But whenever I try to run psql or
> createdb, it fails and I get the message below.
>
> The part which starts 'backend closed the channel....'  always comes up with
> rest of the message varying depending on the message.
>
> psql: pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> createdb: database creation failed
> pq_flush: send<> failed: The connection was aborted
> pq_recvbuf: recv() failed: errno

What version of Cygwin are you running?  Some snapshots (i.e., 20010414
and 20010416) had UNIX domain socket connection problems.

> Question 2
>
> My postgresql.conf file is completely commented out.
>
> Can anyone show me a sample which will at least allow connection via TCP/IP?

Sorry, I can't help you with the above but try the following.  Start
postmaster as follows:

    $ postmaster -i

and psql as follows:

    $ psql -h localhost ...

or createdb as follows:

    $ createdb -h localhost ...

The above with uses TCP sockets instead of UNIX sockets.  Does this work
in your environment?

> Could it be the reason why the commands above are not working?

No.

>I  execute these commands from the cygwin console.

Using a Cygwin console as opposed to cmd.exe/command.com or rxvt should
have no effect.

Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com