On Wed, Sep 01, 2010 at 10:22:20AM -0500, Bayless Kirtley wrote:
> About twice per month, it is necessary to reset the modem and router. This,
> of course, loses the manager's connection to the DB. The problem is, it also
> seems to break the connection at the cash register. The next time it tries to
> record a transaction, it gets the error "Unable to write to the backend" or
> something very close to that. The DB itself seems fine as we can restart the
> cash register and all is well.
>
> Anyone have any idea why this happens? We are running PostgreSQL 8.3.1-1
> and the applications are Java 1.6.14.
I'd guess you're connecting to PG using the network and not staying
within Windows. What does your connection string look like? Getting it
using "localhost" would be my suggestion.
--
Sam http://samason.me.uk/