Re: PostgreSQL for NT - Mailing list pgsql-ports

From Jason Tishler
Subject Re: PostgreSQL for NT
Date
Msg-id 20001127130925.A244@dothill.com
Whole thread Raw
In response to Re: PostgreSQL for NT  ("W. van den Akker" <wvdakker@wilsoft.nl>)
List pgsql-ports
Willem,

On Thu, Nov 23, 2000 at 10:33:49PM +0100, W. van den Akker wrote:
>    C:\Postgres>psql -h localhost -d template1
>    psql: Missing or erroneous pg_hba.conf file, see postmaster log for
>    details

The above is caused by your pg_hba.conf file being a text mode (i.e.,
has CRNL instead of NL line endings) file.  Convert it to a binary mode
file and the above error with be eliminated.

My guess is that your editor accidentally converted pg_hba.conf to text
mode when your were editing it.  Otherwise, you installed Cygwin with
text mode mounts as your default.  You can determine this by using mount,
as in:

    $ mount
    Device              Directory           Type         Flags
    C:\Cygwin\bin       /usr/bin            system       binmode
    C:\Cygwin\lib       /usr/lib            system       binmode
    C:\Cygwin           /                   system       binmode
    ...

If the Flags indicate "textmode" instead of "binmode", then execute
something like the following:

    $ mount -f -b -s C:/Cygwin /
    $ mount -f -b -s C:/Cygwin/bin /usr/bin
    $ mount -f -b -s C:/Cygwin/lib /usr/lib

Otherwise, rerun Cygwin's setup.exe and choose "Unix" for the "Default
Text File Type".

BTW, you may want to reinstall PostgreSQL, since other files may have
been converted to text mode.

Jason

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

pgsql-ports by date:

Previous
From: "S.L."
Date:
Subject: Re: [7.03 on W2K as a service?]
Next
From: "W. van den Akker"
Date:
Subject: Re: PostgreSQL for NT