Alrighty then, it works!
Stripping c:\cygwin from the PGDATA did the trick.
It indeed was mentioned in Kevin Lo's instructions. Just because I had to
run
it from the cmd-prompt I had to place the c:\cygwin in front of the path.
Only PGDATA didn't like that.
Jason, thanks very much.
gr,
Willem
----- Original Message -----
From: "Jason Tishler" <Jason.Tishler@dothill.com>
To: "W. van den Akker" <wvdakker@wilsoft.nl>
Cc: <pgsql-ports@postgresql.org>
Sent: Monday, December 04, 2000 4:57 AM
Subject: Re: [PORTS] PostgreSQL for NT
> Willem,
>
> On Fri, Dec 01, 2000 at 11:24:00PM +0100, W. van den Akker wrote:
> >
> > $ 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
> >
> > [snip]
> >
> > Any ideas?
>
> I use a POSIX style path when I set PGDATA as in the following:
>
> PGDATA=/usr/local/pgsql/data
>
> I was able to reproduce your problem by setting my PGDATA variable to the
> my Win32 equivalent of the above POSIX style path:
>
> PGDATA=c:/cygwin/1.1.4/usr/local/pgsql/data
>
> Hence, you should be able to solve your problem by using the POSIX
> equivalent of your Win32 style PGDATA:
>
> PGDATA=/usr/local/pgsql/data
>
> Have you been following Kevin Lo's instructions? Please see the
following:
>
> http://people.freebsd.org/~kevlo/postgres/portNT.html
>
> I have found it very helpful -- I think that you will too.
>
> 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
>
>