Обсуждение: Re: adding a superuser
I think user root is not known in Postgres user and that's why you want to add it (; try : createuser -d -a -U postgres root As a rule postgres is running under postgres user account that is a superuser. So try psl -U postgres "Karl Babcock" <karl@knbenterprises.com> a �crit dans le message news: _pQo7.71168$xb.37085264@news1.mntp1.il.home.com... > Hi, I have just installed PostgreSQL 7.1 and am having a hard time adding > users. I am trying to add a superuser but I keep getting errors with the > createuser script. > > I am user 'root' on the Linux system when I run: > > lightning:/# createuser -d -a root > psql: FATAL 1: user "root" does not exist > createuser: creation of user "root failed > > Does anyone know how I could create a superuser or any user? > > Thanks in advance, > > Karl > >
I tried that and it says: psql: Peer authentication failed for user 'postgres' createuser: creation of user "root" failed "TeuK" <humpf@yahoo.fr> wrote in message news:9o2dhq$gc$1@front4m.grolier.fr... > I think user root is not known in Postgres user and that's why you want to > add it (; > > try : > > createuser -d -a -U postgres root > > As a rule postgres is running under postgres user account that is a > superuser. > > So try psl -U postgres > "Karl Babcock" <karl@knbenterprises.com> a �crit dans le message news: > _pQo7.71168$xb.37085264@news1.mntp1.il.home.com... > > Hi, I have just installed PostgreSQL 7.1 and am having a hard time adding > > users. I am trying to add a superuser but I keep getting errors with the > > createuser script. > > > > I am user 'root' on the Linux system when I run: > > > > lightning:/# createuser -d -a root > > psql: FATAL 1: user "root" does not exist > > createuser: creation of user "root failed > > > > Does anyone know how I could create a superuser or any user? > > > > Thanks in advance, > > > > Karl > > > > > >
"Karl Babcock" wrote: >I tried that and it says: > >psql: Peer authentication failed for user 'postgres' >createuser: creation of user "root" failed > > >"TeuK" <humpf@yahoo.fr> wrote in message >news:9o2dhq$gc$1@front4m.grolier.fr... >> I think user root is not known in Postgres user and that's why you want to >> add it (; >> >> try : >> >> createuser -d -a -U postgres root >> >> As a rule postgres is running under postgres user account that is a >> superuser. It sounds as though you are using a Debian package (peer authentication is peculiar to the current Debian release and will disappear again when 7.2 is released). The default authentication in Debian is: local all peer sameuser and if that is unchanged, you cannot connect as any user other than your own Unix login id. You need to run this command as Unix user 'postgres': # su - postgres $ createuser -d -a root -- 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 ======================================== "Honour the LORD with thy substance, and with the firstfruits of all thine increase; So shall thy barns be filled with plenty, and thy presses shall burst out with new wine." Proverbs 3:9,10