Re: PostgreSQL for NT

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
>
>