pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in>
To: pgsql-admin@postgresql.org
Subject: Re: pgsql initial superuser
Date: Thu, 03 Jun 2004 17:51:35 +0530
Message-ID: <40BF17CF.50405@sancharnet.in> (raw)
In-Reply-To: <4030FCBF.2020005@netvisao.pt>
References: <4030FCBF.2020005@netvisao.pt>

Dear Pedro ,

> Hello. this is my "first" time using pgsql, and I seem to be running 
> to a bit of a corner here :-)
>
> I've understood how to add a superuser/database-user/user but I have 
> no user to begin with.
>
> ~# createuser superuser
> 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
> psql: FATAL:  user "root" does not exist
> createuser: creation of user "superuser" failed
>

If you have compiled PostgreSQL then the user login  used for initdb is 
the default user
else
this was from  rpm then postgres  is the super user
you may login as

psql -U postgres template1

-- 
Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap[ a t ]jabber.org
ICQ :      264360076
Yahoo  IM: mailforvishal[ a t ]yahoo.com
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
pgsql=# select marital_status from vishals_life;

marital_status
------------------
Single not looking

1 Row(s) affected





view thread (6+ messages)

Message-ID: <40BF17CF.50405@sancharnet.in>
Permalink:  ../40BF17CF.50405@sancharnet.in/
Also on:    postgresql.org/message-id/40BF17CF.50405@sancharnet.in

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: sank89@sancharnet.in
  Subject: Re: pgsql initial superuser
  In-Reply-To: <40BF17CF.50405@sancharnet.in>
  References: <4030FCBF.2020005@netvisao.pt> <40BF17CF.50405@sancharnet.in>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox