From: Tom Lane <tgl@sss.pgh.pa.us>
To: Roeland M.J. Meyer <rmeyer@mhsc.com>
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Remote access ODBC/MS-Access
Date: Fri, 21 Aug 1998 09:59:33 -0400
Message-ID: <15237.903707973@sss.pgh.pa.us> (raw)
In-Reply-To: <199808210658.XAA19347@condor.mhsc.com>
"Roeland M.J. Meyer" <rmeyer@mhsc.com> writes:
>> postgres@condor:/rdbms$> psql customerdb
>> Connection to database 'customerdb' failed.
>> connectDB() failed: Is the postmaster running at 'raven.mhsc.com' on port
> '5432'?
If you look at the code in src/interfaces/libpq/fe-connect.c, you'll
find this message is generated if the connect() system call fails,
which means you don't have connectivity to the postmaster.
You need not worry about whether the database exists or whether
hba.conf allows you to connect, because none of those conditions
can be checked until the postmaster receives the startup request
packet from the client --- and your client is not even getting
as far as sending that packet.
A quick-and-dirty point is did you start the postmaster with -i
on its command line? If not it won't be listening for TCP
connections, only unix-socket connections.
Otherwise it seems like you must have an addressing or physical
connectivity problem of some kind...
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, rmeyer@mhsc.com, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Remote access ODBC/MS-Access
In-Reply-To: <15237.903707973@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