installing postgres on windows2003 server

From: "stealth monkey" <stealthmonkey88(at)msn(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: installing postgres on windows2003 server
Date: 2003-10-08 16:42:56
Message-ID: BAY4-F21SgcOrBLSAQV00018640@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

hi everyone i'm experiencing difficulties getting postgres to work properly

i have installed postgres on the windows 2003 using PgSQL731wina1.exe

my computer name is 'NSXBOX'
i logged in as 'Administrator'

postgres installs but at the end of the installation i get this error

chown 'Administrator.unknown' invalid group

i look in the users and groups for windows 2003 and find this
- there is a user named 'Administrator'
- there is no group named 'Administrator' BUT there is a group named
'Administrators'

i also get some error on needing where to database system will reside

and then it ask me to enter password for 'NSXBOX\Administrator'

i set and re enter the password as ' ' (i just hit enter twice without
typing anything in)

i had a few problems getting the database to start but after some changes i
have successfully started the database

once the database is started i try to create a database

Administrator @nsxbox ~

$ createdb test

i get the error
psql: FATAL: user "Administrator" does not exist
createdb: database creation failed

so then i try to switch users

Administrator @nsxbox ~

$ su Administrator
Password (in enter nothing i just hit enter because that is what i set the
password to)
su:incorrect password

i have been trying to get this database to work for a week now with no
luck..i f anyone could help much would be appreciated....

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2003-10-08 17:23:55 Re: installing postgres on windows2003 server
Previous Message cedric.lemaire 2003-10-08 12:20:52 any SELECT statement in the 'psql' console returns 'SELECT'