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