From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | "Duncan Kinder" <dckinder(at)mountain(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] User not in pg_shadow |
Date: | 1999-08-15 20:02:52 |
Message-ID: | 4.1.19990815165952.00c02db0@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
As the postgres user run the program "createuser" It will ask fro a
username (dckinder) and some other things, including whether the user can
create a database. You can do the same thing by connecting to template1
with psql and using the CREATE USER command. (do \h CREATE USER from within
psql)
At 04:00 PM 8/15/99, Duncan Kinder wrote:
>I have installed postgresql 6.5.1 on a Redhat Linux 5.2 box.
>
>As "postgres" I am able to create a database.
>
>However, when I type the command "createdb whatever" as dckinder, I receive
>the following response:
>
>"Connection to database 'templete1' failed
>FATAL 1: SetUserId: user 'dckinder' is not in 'pg_shadow'.
>
>How do I get dckinder to be in 'pg_shadow'?
>
>Thanks in advance.
>
>Duncan C. Kinder
>dckinder(at)mountain(dot)net
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 1999-08-15 20:04:55 | Re: [GENERAL] Autoincremental |
Previous Message | Duncan Kinder | 1999-08-15 19:00:19 | User not in pg_shadow |