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
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