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
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' |