Обсуждение: adding a superuser
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 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 > >
On Sat, 15 Sep 2001, Karl Babcock wrote: > 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? What does your pg_hba.conf say about local connections?
Karl Babcock" <karl@knbenterprises.com> wrote in 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? Sorry for may poor english. First as root use: su -l postgres after you may use createuser root [root@main /root]# su -l postgres bash-2.04$ /usr/local/pgsql/bin/createuser root Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y CREATE USER Now user root - postgresql superuser. Bye, Max.
Karl Babcock" <karl@knbenterprises.com> wrote in 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? Sorry for may poor english. First as root use: su -l postgres after you may use createuser root [root@main /root]# su -l postgres bash-2.04$ /usr/local/pgsql/bin/createuser root Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y CREATE USER Now user root - postgresql superuser. Bye, Max.
Karl Babcock" <karl@knbenterprises.com> wrote in 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? Sorry for may poor english. First as root use: su -l postgres after you may use createuser root [root@main /root]# su -l postgres bash-2.04$ /usr/local/pgsql/bin/createuser root Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y CREATE USER Now user root - postgresql superuser. Bye, Max.