Thread: Can't connect to instance with pgaccess

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?


--
U.S. Encouraged by Vietnam Vote - Officials Cite 83% Turnout Despite Vietcong Terror
- New York Times 9/3/1967

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