"Dave Cramer" <Dave@micro-automation.net> writes:
> ... My assumption is that something is
> restarting postgres? I suspect that it will drop at exactly the same
> time everyday. At any rate, I don't believe it is the jdbc driver, or
> postgres. I routinely keep connections alive for months.
> One thing that just hit me, do you do a Vacuum in a cron job? Of course
> that would only affect postgres, but it popped in my head.
Another possibility, since postgres is normally run as an unprivileged
user, is that the server is being killed because it's exceeding some
"ulimit" setting. Cure: set limit to unlimited before starting
postmaster. Not sure if mysql is vulnerable to same thing (don't they
prefer to run as root?)
regards, tom lane