Re: Cannot connect though socket

Vinicius Carvalho wrote:
> Hello there! I have a ubuntu 6.06 machine and installed the 8.1
> version of postgres using apt-get.
>
> Well. After the installation I've followed some post-installation
> instructions.
> I've created a database called mydb, and a user with my own linux
> account, all using sudo -su postgres and then using psql.
>
> Well, here's my pg_hba.conf
>
> # IPv4 local connections:
> host    all         all         0.0.0.0 0.0.0.0          password
> host    all         all         127.0.0.1/32          trust
>
> Well, although I can connect using psql from a command line, the same
> cannot be said by a jdbc connection or a pgadmin3 interface. I've
> checked postgres.conf and it has the port=5432 uncommented (isn't this
> enough to allow socket connections?).
>
> Both java and pgadmin interfaces complain about: Postgres: FATAL:
> password authentication failed for user "vinicius"
>
> This is most frustrating...
> Any ideas?

Did you create the "vinicious" user?  If not, you will have to do that,
or connect using the postgres user.

Sean