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