Did You specified the database ? In PostgreSQL You are logging into
database, not into DBMS, like in MySQL.
For test users try template1 first, for example psql -h yourhost -U
somebody -d template1
Did You grant those users rights to database wchich they are connecting
to ?
Regards
Adam
[EMAIL PROTECTED] wrote:
I am new to using postgres. I working on version 8.0.
I have created a number of users in the database but I am not able to
log into it using any of them, where in logging into using user
postgres is successfull .... the commands that i am using are
-- createuser -a -d -P "username"
for logging into , i am using
-- psql -U "username"
In all the references online, it says that the process shud work.
The postmaster service and databases are running.
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
