| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Is there any way to import a portion of a large database |
| Date: | 2011-09-20 06:41:17 |
| Message-ID: | 4E78358D.3040705@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/19/11 11:35 PM, AI Rumman wrote:
> I have a production Postgresql 9 database of 2 TB+. For development
> purpose, I have to import this database in development server where I
> have only 1 TB of disk space. No more space can be added at present.
> Is there any way so that I might import the whole schema definition of
> the database with a portion of data in my development server?
well, you certainly can dump and import just the schema... how are you
going to have this hypothetical partial dump program decide WHAT part of
the various database tables to dump? is the bulk of this data in 1 or
2 very large tables? you could dump everything but those 1 or 2 large
tables, then use some sort of COPY to CSV on those specific tables that
only selects some of the data (maybe by date, or by serial number, or
some other suitable key).
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juan Bru | 2011-09-20 07:48:05 | COLUMNAR postgreSQL ? |
| Previous Message | Craig Ringer | 2011-09-20 06:41:05 | Re: Is there any way to import a portion of a large database |