vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 ankit.mehrotra@tcs.com 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 |
| Thread Tools | |
| Display Modes | |
|
|