Re: Severe problems with ColdFusion 5, ODBC and PostgreSQL 7.2.1

Hi!

Maximum number of connections in postgresql.conf is more than sufficient
and we configured the CF-Servers to use connection pooling so they
cannot reach the limit set in postgresql.conf. I don't think that this
is the cause of my troubles.

Regards,

Markus

-----Ursprüngliche Nachricht-----
Von: mlw
Gesendet: Sa 10.08.2002 17:09
An: Markus Wollny
Cc: pgsql-odbc(at)postgresql(dot)org
Betreff: Re: [ODBC] Severe problems with ColdFusion 5, ODBC and
PostgreSQL 7.2.1

Markus Wollny wrote:
>
> Hi!
>
> We've recently migrated our frontend database from Oracle on
Win2k to
> PostgreSQL 7.2.1 on SuSE Linux 7.2.1. Everything is running -
most of
> the time. But about once every hour, at least one of our three
> webservers running ColdFusion 5 is throwing one of the
following errors:
>
> ODBC Error Code = IM005 (Driver's SQLAllocConnect failed)
> [Microsoft][ODBC Driver Manager] Fehler beim
SQLAllocHandle-Aufruf für
> Treiber auf SQL_HANDLE_DBC.
> (Error calling SQLAllocHandle for Driver on SQL_HANDLE_DBC).
>
> respectively:
>
> ODBC Error Code = S1000 (General error)
> The database does not exist on the server or user
authentication failed.
>
> I've got to restart the ColdFusion Application Server service
in the
> services control panel before the server starts working again.
It seems
> like it just forgets how to connect to the databases from one
moment to
> the next. I don't really know what exactly is going on, so
could anyone
> give me some hints on how to determine the cause of all this
and how to
> resolve the issue?
> Thank you very much!
>
> Regards,
> Markus
>

Check the postgresql.conf file for the maximum number of
connections.

It has been my experience that postgresql is not very well tuned
out of the
box. It is a great system, and I have no doubts about its
capability, but it
usually needs to be tweaked a little after a default install.