On Tue, Jun 27, 2017 at 1:10 PM, DrakoRod <drakoflames(at)hotmail(dot)com> wrote:
> postgres 9741 23340 9 14:55 ? 00:00:47 postgres: dbname user
> 8.8.8.8[54286] idle in transaction
>
> Any suggestions?
>
There is a serious lack of information provided here but "idle in
transaction" sessions are generally problematic (in particular they
continue to hold locks) and can only be fixed at the source - by fixing
code or user behavior.
David J.