Re: pgsql initial superuser

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