Re: Can't connect to instance with pgaccess

stan <stanb@panix.com> writes:

> After several years away from Postgres, I'm back to using it for a small
> project.
>
> I installed 7.4.8 on a FreeBSD 5.4-STABLE machine. Then I init'd the db and
> added myself as a user, then created a ned db for the prohect. I can
> connect fine with psql.
>
> Then I built pgaccess, and p5-DBD-Pg-13 from the FreeBSD ports tree.
> Unfortunately, I can't seem to get either of them to connect. I'm still
> loged in as me, and trying to access the same database, but I can't seem to
> get a conection.
>
> sockstat | grep post returns:
>
> pgsql    postgres   486   4  udp6   ::1:64506             ::1:64506
> pgsql    postgres   485   3  stream /tmp/.s.PGSQL.5432
> pgsql    postgres   485   4  udp6   ::1:64506             ::1:64506
>
> Sorry for the beginer level question, but what am I doing wrong here?

1) You don't have PG listening for connections on a TCP socket (which
   may or may not be the problem).
2) You haven't posted any error messages or log entries.

-Doug