Re: [INTERFACES] Remote access ODBC/MS-Access

"Roeland M.J. Meyer" <rmeyer(at)mhsc(dot)com> writes:
>> postgres(at)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