Neo Liu <diabloneo(at)gmail(dot)com> writes:
> Content of my pg_hba.conf
> local all all peer
> host all all 0.0.0.0/0 md5
> host replication demon_replicator 0.0.0.0/0 md5
Which of those would the stuck processes be using?
Also, can you attach to a few of the stuck processes and get stack traces?
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
regards, tom lane