Francisco Reyes <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
