I install Postgresql from source. It was fairly painless. I have
postmaster up and running as an unpriveledged user 'ralph'. I recompiled
PHP to add Postgresql support, that went swell too.
Next, I wanted to create a new database name Test. Do I do this as root,
as my new user 'ralph', or as my regular unix username? I want the owner
of the database to be fairly unpriveledged too since I plan to access this
database with PHP.
It's sort of confusing in the docs, when I try the examples I'm not
allowed to create a database. I haven't tried as root yet, wanted to ask
for some help first.
Can someone clear up my confusion?
Thanks,
Greg