unable to login to postgresql

veeramani · 11-29-2006, 02:22 AM

when i try to login to postgresql using
psql -h 127.0.0.1 -p 5432 -U user -W database_db

it gives an error database_db not found.

BUT am sure username/passwd/database are correct and exists.
where is the key to open this dead lock????
waiting for your keys...

michaelk · 11-29-2006, 02:42 AM

The correct syntax would be
psql -h hostname -p port -U user -d database

By default psql assumes localhost and the default port (5432) so this will work.
psql -U user database

If your database username is the same as your linux username then all you need is:
psql database

See psql man pages for additional details and well as postgresql documentation. BTW what linux distribution / version are you running and was postgresql installed with the OS or from source.

gruby12 · 11-29-2006, 02:42 AM

Try psql -h 127.0.0.1 -p 5432 -U user database_db