|
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 |
