If I understand correctly, the user "pgsql", besides having its own file
system not related to others, is the administrator of the postgresql db
administrator. Only "pgsql" can modify the db, but the other users can
query the db but not modify it. Am I rigth? What I should do, if other
users ne
Thank you very much Shane. It fixed my problem, at least now :-).
I installed the pgsql 8.2.5 from source. The user "postgres" has a
shortname of "pgsql".
Another question, what's the purpose/advantage to create a user of
postgres? May I just create the database under my user account?
S
Hi, I am a newbie for pgsql and tried to install it on my MacBookPro
Intel. I got everything correct until creating the user: postgres and
initdb, then the error message showed up for running the db. How to fix
the problem?
LizheXusComputer:/Users/lizhexu pgsql$ /usr/local/pgsql/bin/postgres -