Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8FMXM735679; Sat, 15 Sep 2001 18:33:22 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8FMFLM14823; Sat, 15 Sep 2001 18:15:21 -0400 (EDT) (envelope-from news) From: "Karl Babcock" X-Newsgroups: comp.databases.postgresql.docs, comp.databases.postgresql.questions, linux.postgres Subject: adding a superuser Lines: 17 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Message-ID: <_pQo7.71168$xb.37085264@news1.mntp1.il.home.com> Date: Sat, 15 Sep 2001 22:15:22 GMT X-Complaints-To: abuse@home.net Organization: Excite@Home - The Leader in Broadband http://home.com/faster To: pgsql-docs@postgresql.org.pgsql-general@postgresql.org X-Archive-Number: 200109/39 X-Sequence-Number: 973 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