Francisco Reyes <lists(at)stringsutils(dot)com> writes:
> Trying to pg_dump as superuser or as the database owner, freezes.
Define "freezes". What happens exactly --- is the pg_dump or its
backend consuming CPU, or just sitting? What do ps and pg_stat_activity
and pg_locks show that it's doing?
(I'm speculating in particular that someone is holding an exclusive lock
on one of the tables to be dumped --- if so pg_locks would tell the tale.)
regards, tom lane