From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jim.Lemon@uts.EDU.AU
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] pgaccess startup
Date: Mon, 05 Jul 1999 19:57:52 -0400
Message-ID: <22523.931219072@sss.pgh.pa.us> (raw)
In-Reply-To: <37813B27.D3FF98C4@uts.edu.au>
Jim Lemon <Jim.Lemon@uts.EDU.AU> writes:
> Error connecting database
> Connection to database failed
> connectDB() failed: Is the
> postmaster running and
> accepting TCP/IP (with -i)
> connections at 'localhost' on
> post '5432'?
> This error message changes slightly (and appropriately) when I change
> the host to 'tobermory' (which is the host name). Unfortunately, I do
> not know what the port number of the postmaster is, nor do I know how to
> find this out.
The default installation uses 5432 as the port number --- if you had
changed that when you installed, you'd probably know it. My guess is
you didn't start the postmaster with the "-i" command line switch,
so it's not listening for a TCP connection, only Unix socket
connections.
psql will default to trying to connect via a Unix socket, so it'll
still work without -i, but I believe pgaccess always tries TCP/IP
connections, so it won't. Certainly the above error message indicates
that a TCP/IP connection is being attempted.
There has been some talk of making -i the default postmaster behavior,
but for now it's not.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, Jim.Lemon@uts.EDU.AU, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] pgaccess startup
In-Reply-To: <22523.931219072@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox