From: Joe Shevland <shevlandj@kpi.com.au>
To: Don Oliver <dayo_nanaimo@hotmail.com>
To: pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] Pgaccess - Error trying to connect
Date: Thu, 2 Mar 2000 11:35:20 -0800
Message-ID: <NDBBLJFAELMHMDPDFAGLMELICAAA.shevlandj@kpi.com.au> (raw)
In-Reply-To: <20000302002021.29212.qmail@hotmail.com>
Do a:
netstat -an
and check if anything is listening on port 5432.
Also, try looking at your ODBC data source definition
and check the hostname/IP address setting.
Once you've verified this, try pinging that hostname
or IP address from your DOS-prompt to see if its
reachable via TCP/IP.
HTH,
Joe
-----Original Message-----
From: owner-pgsql-interfaces@postgreSQL.org
[mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Don Oliver
Sent: Wednesday, 1 March 2000 4:20 PM
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Pgaccess - Error trying to connect
>Ed Loehr wrote>
>May I suggest you search deja.com for your error message?
been there, done that :-)
>If that fails, you might post your error message on the mailing list and
>see
>what people say. Probably others struggled with the same and would
>benefit from a solution...
>
I thought that I did explain above, but I'll start over here. Maybe I wasn't
clear.
I'll list every step. Please excuse the length, but I'm going around in
circles here.
I am logged into linux as user "don".
I have PostgreSQL permissions to create databases.
I have a database named "don", and I have created and populated tables in
this database.
PostgreSQL is always on, and works fine from the command line. (A console in
X.)
If I try to start pgaccess with: "pgaccess don", the main PgAccess window
comes up,
(empty) but there is an error message box in front of it. The message is:
"Error trying to connect to database "don" on host localhost.
PostgreSQL error message: Connection to database failed:
Network is unreachable. is the postmaster running (with -i) at
'localhost' and accepting connections on TCP/IP port '5432'?"
In the PgAccess file there is a page called "Common Problems with PgAccess"
The first one is called "Connection Failure", which says:
"one of the most common initial problems is the message:"
(then repeats exactly the message that I just listed).
It goes on to say, "This usually occurs because the "postmaster" (the
postgreSQL backend)
was not started with the -i option. Usually just adding -i to the command
line that starts
the postmaster and restarting will fix this."
So I did:
$su
# /etc/rc.d/init.d.postgresql stop
(it stops)
# /etc/rc.d/init.d.postgresql start -i
$ pgaccess don
I still get the same error
It then goes on to say, "If you have installed the prewritten script to
start postgreSQL
automatically, this option is (currently) commented out:
# PGOPTS="-i"
just remove the hash and space and comment out the "blank" option above.
PGOPTS="".
This line did not exist in the startup script, so I added it. PGOPTS=-i
Still the same error.
I can not find any other clues, so I'm stuck, and hoping someone will have
another idea.
TIA,
Don
Sorry Ed, I meant to send this to the list, then realized that I was
replying to you. I'm re-sending it to the list. Don
Don Oliver
dayo_nanaimo@hotmail.com
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
************
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: shevlandj@kpi.com.au, dayo_nanaimo@hotmail.com
Subject: RE: [INTERFACES] Pgaccess - Error trying to connect
In-Reply-To: <NDBBLJFAELMHMDPDFAGLMELICAAA.shevlandj@kpi.com.au>
* 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