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(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com