pg_dump a schema with data

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

Responses

Browse pgsql-admin by date

  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