On Thu, 4 Jan 2001, Richard Tidd wrote:
> I have a question regarding the creation of users (I think). Anyway, I
> am running Mandrake 7.2, which installs postgres during the linux
> install. I see during startup that the postmaster is started. I got
> the following result:
>
> [rick@fuller ~]$ createdb mydb
> psql: FATAL 1: SetUserId: user 'rick' is not in 'pg_shadow'
> createdb: database creation failed
su root
password: teh root pass in your machine
then
su postgres
%> CREATE USER rick
folow the simple instructions and exit su.
The user now is postgres recognized.
Luck.
Fernando
>
> 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.
>
> Please help.
>
> Rick
>