Francisco Reyes <lists@xxxxxxxxxxxxxxxx> 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
