pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDROP TABLE waiting for pg_dump
2+ messages / 2 participants
[nested] [flat]
* DROP TABLE waiting for pg_dump
@ 2008-10-02 11:33 Daniel Cristian Cruz <danielcristian@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Daniel Cristian Cruz @ 2008-10-02 11:33 UTC (permalink / raw)
To: pgsql-admin
Helllo,
I had a huge database with a dump backup routine.
I had a problem today, where pg_dump was locking a concurrent DROP TABLE,
and it was another table, not the table in the COPY running. Is it normal?
Some kind of bug or is it expected?
I'm using 8.2.4 (I need to rewrite dblink functions before upgrade).
Regards,
--
Daniel Cristian Cruz
クルズ クリスチウ３柑ン ダニエル
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: DROP TABLE waiting for pg_dump
@ 2008-10-02 12:11 Tom Lane <tgl@sss.pgh.pa.us>
parent: Daniel Cristian Cruz <danielcristian@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2008-10-02 12:11 UTC (permalink / raw)
To: Daniel Cristian Cruz <danielcristian@gmail.com>; +Cc: pgsql-admin
"Daniel Cristian Cruz" <danielcristian@gmail.com> writes:
> I had a problem today, where pg_dump was locking a concurrent DROP TABLE,
> and it was another table, not the table in the COPY running. Is it normal?
Yes. pg_dump acquires ACCESS SHARE lock on all the tables it's
intending to dump. Without that it couldn't guarantee a consistent
dump.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-10-02 12:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-02 11:33 DROP TABLE waiting for pg_dump Daniel Cristian Cruz <danielcristian@gmail.com>
2008-10-02 12:11 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox