> Logged in as postgres, I created a role as Superuser. psql returned
> CREATE ROLE.
> When I enter \du it lists the new role, however, createdb and
> createrole are listed as "no". I thought superusers bypassed all
the real superuser user account is postgres. If you want to create a role that will have more
than the default priveledges you must granted:
> When I \q, psql returns "could not save history to file "/Users/
> postgres/.psql_history": Invalid argument". Of what significance is
> this at this point and how do I correct it?
I expect that mean that your postgres unix user account doesn't have a home directory to save
these files. At home directory is created by default on my system either.
I tried this with and
> without the -U flag. Any clue as to what is going on?
if you do not specify an actual postgresql db account it tries to use your unix user account
instead. If your unix user name doesn't exist in postgresql you get this error.
try "-U <one of you postgresql usernames>"
The following link should give 80% of everything you want to know.
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: nhrcommu||Date: 2006-12-19 22:07:10|
|Subject: Re: CREATE ROLE|
|Previous:||From: Frank Bax||Date: 2006-12-19 21:27:03|
|Subject: Re: print statements?|