installing postgres on windows2003 server - Mailing list pgsql-cygwin

From stealth monkey
Subject installing postgres on windows2003 server
Date
Msg-id BAY4-F21SgcOrBLSAQV00018640@hotmail.com
Whole thread Raw
Responses Re: installing postgres on windows2003 server
List 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


pgsql-cygwin by date:

Previous
From: cedric.lemaire@bnpparibas.com
Date:
Subject: any SELECT statement in the 'psql' console returns 'SELECT'
Next
From: Jason Tishler
Date:
Subject: Re: installing postgres on windows2003 server