On Sat, Sep 14, 2013 at 11:28 AM, Craig James <cjames@xxxxxxxxxxxxxx> wrote:
I'm trying to do a pg_dump of a database, and it more-or-less just sits there doing nothing.
What is running in the db? Perhaps there is something blocking the pg_dump? What does the output of the following query look like?
select * from pg_stat_activity where pid <> pg_backend_pid()