Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL for NT

From: Jason Tishler <Jason(dot)Tishler(at)dothill(dot)com>
To: "W(dot) van den Akker" <wvdakker(at)wilsoft(dot)nl>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-ports(at)postgresql(dot)org
Subject: Re: PostgreSQL for NT
Date: 2000-11-27 18:09:25
Message-ID: 20001127130925.A244@dothill.com (view raw or flat)
Thread:
Lists: 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(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

In response to

Responses

pgsql-ports by date

Next:From: Joyce GaoiranDate: 2000-11-27 23:41:42
Subject: ./configure returns errors
Previous:From: S.L.Date: 2000-11-24 09:44:36
Subject: Re: [7.03 on W2K as a service?]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group