Re: [SQL] createuser problem
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 [EMAIL PROTECTED] 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? > >
Re: [SQL] createuser 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[EMAIL PROTECTED] 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 upon us." Psalms 67:1
[SQL] createuser problem
It gives the following error when i tried to a new user createuser demouser1Connection to database 'template1' failed.FATAL 1: SetUserId: user 'fion' is not in 'pg_shadow' how should i solve this problem?
Re: [SQL] createuser
Craig May writes: > createuser -adq username > > returns > > invalid option adq createuser -a -d -q -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
[SQL] createuser
Hi, I'm having trouble with the createuser command. createuser -adq username returns invalid option adq Could someone post an example using these args. Regards, Craig May Enth Dimension http://www.enthdimension.com.au