Thread: 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