GV wrote:
Hi there,
as I'm a newbie in postgres (till now used to have MySQL and ORACLE!) I was
trying to log in via "psql". The system keeps rejecting me due to a wrong
user!!! What's the "root" user for Postgres and do I have to give a password?
Using Mandrake 10.1 and Postgres 7.4.5
Thanks for your help
It is not that simple in Postgres. When you install the system, there
is only one user created, normally 'postgres'. What you want to do is,
from root, to switch to user postgres (su - postgres) and then create a
new user for yourself. Good documentation can be found at
http://www.postgresql.org/docs/7.4/interactive/index.html and more
specifically about users:
http://www.postgresql.org/docs/7.4/interactive/user-manag.html
You may also want to subscribe to some of the postgres mailing lists.
Avi
--
Avi Schwartz
http://public.xdi.org/=avi.schwartz
____________________________________________________
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
Join the Club : http://www.mandrakeclub.com
____________________________________________________
