[PERFORM] pg_dump blocking create database?

2007-09-12 Thread Dan Harris
My PG server came to a screeching halt yesterday. Looking at top saw a very large number of startup waiting tasks. A pg_dump was running and one of my scripts had issued a CREATE DATABASE command. It looks like the CREATE DATABASE was exclusive but was having to wait for the pg_dump to

Re: [PERFORM] pg_dump blocking create database?

2007-09-12 Thread Tom Lane
Dan Harris [EMAIL PROTECTED] writes: My PG server came to a screeching halt yesterday. Looking at top saw a very large number of startup waiting tasks. A pg_dump was running and one of my scripts had issued a CREATE DATABASE command. It looks like the CREATE DATABASE was exclusive