Re: PostgreSQL for NT

From: "W(dot) van den Akker" <wvdakker(at)wilsoft(dot)nl>
To: "Jason Tishler" <Jason(dot)Tishler(at)dothill(dot)com>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, <pgsql-ports(at)postgresql(dot)org>
Subject: Re: PostgreSQL for NT
Date: 2000-12-01 22:24:00
Message-ID: 003c01c05be5$67cbecf0$0400020a@wilsoft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Jason,

All mounts are in binary mode. So that sounds ok. Next I have compiled and installed postgres 7.03
like discribed in Tishlers docu. All went ok.
If I start postmaster I get:

$ DEBUG: Data Base System is starting up at Fri Dec 1 22:57:01 2000
DEBUG: Data Base System was interrupted being in production at Fri Dec 1 18:48:58 2000
DEBUG: Data Base System is in production state at Fri Dec 1 22:57:01 2000

Then I try to start psql -h localhost template1 and get:

$ psql -h localhost template1
NOTICE: mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_log: No such file or directory
NOTICE: mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_log: No such file or directory
NOTICE: mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_variable: No such file or directory
NOTICE: mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_log: No such file or directory
FATAL 1: cannot open relation pg_log
NOTICE: mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_variable: No such file or directory
NOTICE: mdopen: couldn't open c:/cygwin/usr/local/pgsql/data/pg_log: No such file or directory
psql: FATAL 1: cannot open relation pg_log

The /usr/local/pgsql/data directory looks like:

$ ls -al
total 47
drwxr-xr-x 4 wvdakker None 4096 Dec 1 22:57 .
drwxr-xr-x 6 wvdakker None 0 Dec 1 16:14 ..
-rw-r--r-- 1 wvdakker None 4 Dec 1 18:30 PG_VERSION
drwxr-xr-x 3 wvdakker None 0 Dec 1 18:30 base
-rw-r--r-- 1 wvdakker None 8192 Dec 1 22:57 pg_control
-rw-r--r-- 1 wvdakker None 8192 Dec 1 18:30 pg_database
-r--r--r-- 1 wvdakker None 3407 Dec 1 18:30 pg_geqo.sample
-rw-r--r-- 1 wvdakker None 0 Dec 1 18:30 pg_group
-rw-r--r-- 1 wvdakker None 16384 Dec 1 18:30 pg_group_name_index
-rw-r--r-- 1 wvdakker None 16384 Dec 1 18:30 pg_group_sysid_index
-r--r--r-- 1 wvdakker None 5729 Dec 1 18:30 pg_hba.conf
-rw-r--r-- 1 wvdakker None 8192 Dec 1 18:30 pg_log
-rw-r--r-- 1 wvdakker None 8192 Dec 1 18:30 pg_shadow
-rw-r--r-- 1 wvdakker None 8192 Dec 1 18:30 pg_variable
drwxr-xr-x 2 wvdakker None 0 Dec 1 18:30 pg_xlog
-rw-r--r-- 1 wvdakker None 122 Dec 1 22:57 postmaster.opts
-r--r--r-- 1 wvdakker None 1 Dec 1 18:30 postmaster.opts.default
-rw-r--r-- 1 wvdakker None 4 Dec 1 22:57 postmaster.pid

I also exported all environment variables, PGDATA PGLIB and PATH.
I'am running this on NT4 SP6.

Any ideas?

gr,
Willem

----- Original Message -----
From: "Jason Tishler" <Jason(dot)Tishler(at)dothill(dot)com>
To: "W. van den Akker" <wvdakker(at)wilsoft(dot)nl>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>; <pgsql-ports(at)postgresql(dot)org>
Sent: Monday, November 27, 2000 7:09 PM
Subject: Re: [PORTS] 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
>
>

In response to

Responses

Browse pgsql-ports by date

  From Date Subject
Next Message ric Prvost-Dansereau 2000-12-02 19:58:06 Run postmaster as a NT service with invoker 1.53
Previous Message Shonda Sparks 2000-11-29 21:59:17 Postgresql Compile Error