Обсуждение: createuser problem
It gives the following error when i tried to a new user
createuser demouser1
Connection to database 'template1' failed.
FATAL 1: SetUserId: user 'fion' is not in 'pg_shadow'
Connection to database 'template1' failed.
FATAL 1: SetUserId: user 'fion' is not in 'pg_shadow'
how should i solve this problem?
"fion yong" wrote: >It gives the following error when i tried to a new user > >createuser demouser1 >Connection to database'template1' failed. >FATAL 1: SetUserId: user 'fion' is not in 'pg_shadow' > >how should i solve this problem? Become user postgres before you try to run createuser. (Or become any user who has create user privilege.) -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "God be merciful unto us, and bless us; and cause his face to shine uponus." Psalms 67:1
run this as user 'postgres' instead of 'fion' Jie LIANG St. Bernard Software Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.stbernard.com www.ipinc.com On Tue, 13 Feb 2001, fion yong wrote: > It gives the following error when i tried to a new user > > createuser demouser1 > Connection to database 'template1' failed. > FATAL 1: SetUserId: user 'fion' is not in 'pg_shadow' > > how should i solve this problem? > >