PostgreSQL transaction locked database table: "idle in transaction"
What you are seeing are transactions which are running, holding locks, and not doing anything.  What you need to do is trace the transactions back to their source and find out what they are doing.  They may be other admins who have logged in and forgot to log out.

In general it is usually a bad thing to hold transactions open and idle for a long time due to this sort of locking problem.