Re: Postgres Port Problem (and other port issues)
On Mon, 4 Dec 2000 04:51:50 -0800 (PST)
Chris Mayes <cmayes3@yahoo.com> wrote:
> > Set
> > PGALLOWTCPIP=yes
> > in /etc/postgresql/postmaster.init and restart postgres.
> >
> Well, nmap (and lsof) reports that the postgres port is open and
> listening, but I still get:
>
> ------------
> psql: connectDBStart() -- connect() failed: Connection refused
> Is the postmaster running at 'localhost'
> and accepting connections on Unix socket '5432'?
> ------------
>
> ...whenever I try to run psql (or the regression tests, which use
> psql). What else could be the problem? Could it be the psql client?
> Is there a way for me to test for connectivity without using psql?
Another problem might be that you have no access permissions, that the
database wasn't yet initialized or that there is just no database at
all. But those, I believe, would cause different messages. The only
way I know of not using psql is writing some program using the
libraries (e.g., libpsql) or using some application based on postgres,
but then, I wouldn't expect any difference. Sorry. No more ideas.
--
Christoph Simon
ciccio@prestonet.com.br
---
^X^C
q
quit
:q
^C
end
x
exit
ZZ
^D
?
help
shit
.
Reply to: