Обсуждение: User not in pg_shadow

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@mountain.net

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@mountain.net
>
>
>
>
>

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'?

Use the program createuser as user postgres. Type man createuser
for explanation.


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                            E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services               Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

"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'?

As postgres, createuser dckinder

--
      Vote against SPAM: http://www.politik-digital.de/spam/
                 ========================================
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Praying always with all prayer and supplication in the
      Spirit, and watching thereunto with all perseverance
      and supplication for all saints."       Ephesians 6:18