stan <stanb@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
