Re: Can't connect to instance with pgaccess - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Can't connect to instance with pgaccess
Date
Msg-id m21x3ydklv.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Can't connect to instance with pgaccess  (stan <stanb@panix.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: stan
Date:
Subject: Can't connect to instance with pgaccess
Next
From: "Van Tress,Michael J - PGPW"
Date:
Subject: ecpg -C INFORMIX