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