Re: Postgres on NT

I have simila yet different problems...

It seems that we are some NT folks with startup problems. Therefore, I took
the liberty to include my hurdles in this thread...

The downloaded binaries <postgresql-7.0-nt-binaries.tar.gz> didn't work for
me on windows2000.

Instead I tried to compile the \src\win32.mak on windows2000 with nmake from
MS VC++ 5.0 as described in
http://www.postgresql.org/users-lounge/docs/7.0/postgres/install-win32.htm
(these instructions are meant for pgsql v.6.4.).
I used the full download <postgresql-7.0.2.tar.gz> taken from the FTP site
<ftp://ftp.sunsite.auc.dk/disk1/www.postgresql.org/pub/source/v7.0.2/>

I got the following error:
***
startup.c<25> : fatal error C1083: Cannot open include file: 'version.h'
***
I solved this by copying version.h from the library "\src\include\commands"
to "\src\bin\psql"

This way I have the 4 files mentioned in
http://www.postgresql.org/users-lounge/docs/7.0/postgres/install-win32.htm

I copy the newly built libpq.dll to c:\winnt\system32, try to run psql.exe
and I get another error:
***
psql.exe: connectDBStart() -- socket() failed: errno=0
No error
***
This is where I am stuck.
I hope there are some more experienced pgsql-NT people outhere who can help

Regards
Dan Manczak

----- Original Message -----
From: "Assefa Yewondwossen" <assefa(at)dmsolutions(dot)on(dot)ca>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Friday, August 25, 2000 7:56 PM
Subject: [NOVICE] Postgres on NT

> Hi All,
>
> I have downloaded NT binaries and would like to start using postgres. I
>
> have checked the tutorials but could not get started correctly.
>
> The tar files dowloaded do not have a postmaster executable (I do not
> no if it is necessary on NT or it is just a on UNIX).
>
> I tried to start posgres.exe and I get the following message :
>
> $ postgres
> DEBUG: Data Base System is starting up at Thu Aug 24 10:12:16 2000
> DEBUG: Data Base System was interrupted being in production at Wed Aug
> 23 17:18
> :25 2000
> DEBUG: Data Base System is in production state at Thu Aug 24 10:12:16
> 2000
> FATAL 1: Version number in file 'd:\proj\pgsql\data/PG_VERSION' should
> be 7.0
> , not 7.0
> .
> FATAL 1: Version number in file 'd:\proj\pgsql\data/PG_VERSION' should
> be 7.0
> , not 7.0
> .
> I do not really understand why there is fatal error on the version
> (seems to be the same).
>
>
> When I tried other executables :
>
> $ psql
> psql: connectDBStart() -- connect() failed: No such file or
> Is the postmaster running at 'localhost'
> and accepting connections on Unix socket '5432'?
>
>
> Any help would be really appreciated to get me started.
>
>
> Thanks
>
>
>
>
>