Hi,
=20
We're running postgres7.3 on RedHat7.3. The Postgres at boot time is
started up from a java (1.2) class that runs the following commands in
order:
=20
/usr/local/pgsql/bin/pg_ctl -w start -D /var/lib/pgsql -l
/var/log/pgsqld.log -o -i
/usr/local/pgsql/bin/createdb management
=2E
=2E
=2E
=20
As you can tell the postmaster starts up with "-i" option here.=20
=20
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
In pg_hba.conf we have:
local all all
trust
host all all 127.0.0.1 255.255.255.255
trust
host all all 192.168.0.0 255.255.0.0
trust
=20
The host IP address is 192.168.55.5 which is in the right subnet.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
In postgresql.conf:=20
=20
#
# Connection Parameters
#
tcpip_socket =3D true
#ssl =3D false
=20
max_connections =3D 64
#superuser_reserved_connections =3D 2
=20
#port =3D 5432=20
#hostname_lookup =3D false
#show_source_port =3D false
=20
#unix_socket_directory =3D ''
#unix_socket_group =3D ''
#unix_socket_permissions =3D 0777 # octal
=20
As you can see tcpip_socket =3D true
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
=20
=20
Sometimes, after Postgres starts up, when the database clients try to
access the db from the localhost, we get the following error:
=20
com.solarmetric.kodo.Runtime -
com.solarmetric.kodo.runtime.FatalDataStoreException: Connection
refused. Check that the hostname and port are correct and that the
postmaster is accepting TCP/IP connections.=20
=20
Any ideas what's causing postmaster NOT to accept connections some of
the time?
=20
This problem almost always goes away upon rebooting the machine.
=20
Any help is much appreciated.
=20
Thanks,
-Allen
=20
***************************************************************************=
***********
This email message and any files transmitted with it contain confidential i=
nformation intended only for the person(s) to whom this email message is ad=
dressed. If you have received this email message in error, please notify th=
e sender immediately by telephone or email and destroy the original message=
without making a copy. Thank you.
***************************************************************************=
***********
