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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
