Re: PostgreSQL for NT

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