| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Colton A Smith <smith(at)cs(dot)utk(dot)edu> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_dump and truncate |
| Date: | 2005-11-03 19:31:19 |
| Message-ID: | 20051103193119.GU55520@pervasive.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Nov 03, 2005 at 11:43:37AM -0500, Colton A Smith wrote:
> Hi:
>
> While pg_dump is dumping my database, I find that when I try to truncate
> a table the query hangs. Is that the expected behavior? What if I try
> to drop a table? Will that hang as well?
Yes. dump grabs an AccessSharedLock on everything it's going to dump.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Minion | 2005-11-03 20:31:18 | Re: How to start postresql db server as a administrator on windows platform? |
| Previous Message | Jim C. Nasby | 2005-11-03 19:21:30 | Re: Pre-allocation of space: a business rationale |