Problem with host connection

Hello Jeremy...

Jeremy Smith wrote:

This is a new area to me, I am rewriting a Microsoft Access
application for the company

Have you tried using PgAdmin? It may help you a bit... Then just iron
out the details afterwards...;-) It's somewhere in
www.greatbridge.com... I think..;-)

I work for in Java and Postgres.

JDBC...

I have created a testdatabase called history which I can access with
<psql history> fine
as well as from a Perl test app I have written.
But if I try to specify a host in either my Java test app or psql I
get the same
error message

Connection to database 'history' failed.
connectDB() -- connect() failed: Connection refused
Is the postmaster running (with -i) at '127.0.0.1' and accepting
connections on TCP/IP port '5432'?

try a

netstat -a | grep postgres

I also have the same errors when runing under the postgres account.

<psql history> works fine

<psql -p 5432 history) also works fine

<psql -h 127.0.0.1 -p 5432 history> give the following error message
Connection to database 'history' failed.
connectDB() -- connect() failed: Connection refused
Is the postmaster running (with -i) at '127.0.0.1' and accepting
connections on TCP/IP port '5432'?

<psql -h 192.168.1.168 -p 5432 history> gives the same error

THE NETWORK SEEMS OK:
PING 127.0.0.1 (127.0.0.1) from 127.0.0.1 : 56(84) bytes of data.
64 bytes from 127.0.0.1: icmp_seq=0 ttl=255 time=0.2 ms

PING 192.168.1.168 (192.168.1.168) from 192.168.1.168 : 56(84) bytes
of data.
64 bytes from 192.168.1.168: icmp_seq=0 ttl=255 time=0.2 ms

THE FILE /etc/rc.d/init.d/postgresql contains the following line
su -l postgres -c '/usr/bin/postmaster -i -S -D
/var/lib/pgsql/data'
# originaly the -D variable was /var/lib/pgsql but I changed it to the
same as the PGDATA
# setting
# neither seems to make any difference - jeremy

This is how it is started in my machine...;-(

su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster
start >/dev/null 2>&1"

The -i option is with /var/lib/pgsql/data/postmaster.opts in my
machine...

THE FILE /var/lib/pgsql/data/pg_hba.conf contains the following lines
at the end:
local all trust
host all 127.0.0.1 255.255.255.255 trust

As for PGDATA, it's in the script...

if [ -f /var/lib/pgsql/PG_VERSION ] && [ -d
/var/lib/pgsql/base/template1 ]
then
export PGDATA=/var/lib/pgsql
else
export PGDATA=/var/lib/pgsql/data
fi

What version of PostgreSQL are you running? What O.S. are you running
it in? And how did you install postgresql?

Cheers,

John Clark

--
/) John Clark Naldoza y Lopez (\
/ ) Software Design Engineer II ( \
_( (_ _ Web-Application Development _) )_
(((\ \> /_> Cable Modem Network Management System <_\ </ /)))
(\\\\ \_/ / NEC Telecom Software Phils., Inc. \ \_/ ////)
\ / \ /
\ _/ phone: (+63 32) 233-9142 loc. 3112 \_ /
/ / cellphone: (+63 919) xxx-xxxx \ \
/ / email: njclark@ntsp.nec.co.jp \ \

Hi, Thanks for your response.

netstat did not find postgres ?????????
I do not have a postmaster.opts
I am running version 6.5 on a Mac using Yellowdog Linux 1.2

Jeremy

From: "Jeremy Smith" <Jeremy@justasofty.com>

Hi, Thanks for your response.

netstat did not find postgres ?????????

If netstat doesn't list it (nr the top, with a Proto of tcp) then it isn't
listening. The other test is to "telnet localhost 5432" which should show
nothing if pg is listening, connection refused otherwise.

Try "/etc/rc.d/init.d/postgresql restart" and see if that helps and if not
whether there is anything useful in the logs. Failing that, su to postgres
and run the command-line by hand - there should be some sort of error
message.

I do not have a postmaster.opts
I am running version 6.5 on a Mac using Yellowdog Linux 1.2

These two things are connected, don't worry about postmaster.opts since that
was introduced in 7.0/1.

You should have no problem compiling 7.x from source when you want to
upgrade - worked just fine on my iBook running LinuxPPC.

Jeremy Smith <Jeremy@justasofty.com> writes:

This is a new area to me, I am rewriting a Microsoft Access
application for the company I work for in Java and Postgres. I have
created a testdatabase called history which I can access with <psql
history> fine as well as from a Perl test app I have written. But
if I try to specify a host in either my Java test app or psql I get
the same error message

Connection to database 'history' failed.
connectDB() -- connect() failed: Connection refused
Is the postmaster running (with -i) at '127.0.0.1' and accepting connections
on TCP/IP port '5432'?

By all evidence you're not running the postmaster with '-i'. Chechk
your startup script.

-Doug

Hi, After listening to others it seems best to run 7.0 and so rather than
carry on I decided to remove all traces of 6.5 and install 7.0 once I have
downloaded it. (have not had chance yet, hope to tonight)

At the same time while removing 6.5 I did notice a running of postmaster at
the end of my inittab which did not have a -i in it so I think that was the
problem?

Jeremy