|| at Jan 4, 2001 at 3:30 pm
I assume that this means that my user id is not yet valid under
postgres. The section in the admin document labelled "Creating Users"
is empty. The documentation does talk about "becoming user postgres".
I am not sure what I need to do for this either.
First of all, here's the URL of some notes I wrote about 2 years ago. They
should still be good as PostgreSQL hasn't changed much in the "getting
... I think you'll find the notes contained there a acceptable tutorial as
it is basically a journal of my learning the basics.
To more directly answer your question, I can su to the "postgres" user
where the commands "createuser" and "createdb" allow you to create
PostgreSQL users and databases for those users. I have found it convenient
to create db users and databases of the same name as the loginid, as the
"psql" command which is a command line SQL tool will assume the loginid
for both the db user and the database name if you provide no other
I hope that helps.
Bruce Tong | Got me an office; I'm there late at night.
Sr. Software Engineer | Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE |
firstname.lastname@example.org | -- Joe Walsh for the 21st Century