|
发表于 2003-9-1 16:40:43
|
显示全部楼层
I dont have Chinese input program in my computer, but my instructions should be easy to follow.
I encoutered this problem earlier, but has been solved, haha. The point is redhat does not have directory called "/usr/local/pgsql", so I reckon the psql guy configured in some different way within this particular distribution. Anyway, here is the solution:
When you run "rpm -ql postgresql | head -20", you probably see a line "/usr/bin/createuser". That is the key, because POSTGRESQL USER DOES NOT CORRESPOND DIRECTLY TO SYSTEM USER. So you have to explicitly register it to postgresql. The default root for postgresql is "postgres", you can login in this account, use "createuser" to make a system user as postgresql user (check out man pages for createuser yourself, I don't go details here). That is it, or you can simply do you work in this accout, createdb, dropdb whatever.
Above is the wolkthrough, clear? |
|