From: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_dump a schema with data |
Date: | 2015-07-10 20:03:06 |
Message-ID: | B75CD08C73BD3543B97E4EF3964B7D701FF39921@CITESMBX1.ad.uillinois.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
PostgreSQL 9.4
Assume you do the following command which dumps all of the data associated with a schema:
pg_dump -schema=schemaName dbName > schemaName.out
Assume there are some 50 tables in the schema. Some of these tables have foreign keys to each other. During the dump of the schema, I would assume each table would be frozen/locked while it is being dumped. But what about tables that have associates to a table that is being written out. Will they be locked/frozen also. Or does postgresql lock up all of the tables within the schema while it is being dumped. Or are you just taking a risk that there might be miss associations between tables once the dump is complete.
My guess is that individual tables are locked/frozen while writing. I would also assume there might be relationship issues between related tables if there was a lot of writing or deleting during the dump.
Thanks,
Lance Campbell
University of Illinois
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2015-07-10 20:24:16 | Re: pg_dump a schema with data |
Previous Message | Keith | 2015-07-10 14:46:24 | Re: Automatic restore corruption problem |