Hello there, pgsql-admin!
trying to install PostgreSQL on WinNT.
downloaded binary files from ftp and complete cygwin package from
cygnus.com
installed both of them.
cygwin.bat:
@echo off
SET MAKE_MODE=unix
SET PGLIB=/usr/local/pgsql/lib
SET PGDATA=/usr/local/pgsql/data
SET USER=postgres
SET PATH=e:\\bin;e:\\usr\\local\\bin;e:\\usr\\local\\pgsql\\bin;%PATH%
bash
starting initdb, it builds data. starting postgres.exe. it writes:
FATAL 1: Database administrator does not exist in pg_database
FATAL 1: Database administrator does not exist in pg_database
and exits. if i start postgres -d 3 it writes:
===============================================================
FindExec: searching PATH ...
ValidateBinary: can't stat "/usr/bin/postgres"
ValidateBinary: can't stat "/usr/local/bin/postgres"
FindExec: found "/usr/local/pgsql/bin/postgres" using PATH
debug info:
User = administrator
RemoteHost =
RemotePort = 0
DatabaseName = administrator
Verbose = 3
Noversion = f
timings = f
dates = Normal
bufsize = 64
sortmem = 512
query echo = f
InitPostgres
binding ShmemCreate(key=0, size=864256)
FATAL 1: Database administrator does not exist in pg_database
FATAL 1: Database administrator does not exist in pg_database
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
===============================================================
so what should i do?
Slava 'SLY' Golovanov
Chief Engineer,
Absolute Games, http://www.ag.ru