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:
Show quoted text
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'?
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