Re: pg_dump --exclude-table-data

From: bricklen <bricklen(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump --exclude-table-data
Date: 2011-08-24 21:51:13
Message-ID: CAGrpgQ8eG=fDQoJw10q38bkdbU06BZk9TvTY9inTZgzHPuBoCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Aug 24, 2011 at 2:01 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
> FWIW, I have immediate use for this in creating cut-down versions of
> databases for testing purposes.  It'll eliminate a couple pages of shell
> scripts for me.

Speaking of "cut-down versions", I have recently been using pg_sample,
and been happy with the resulting subset database. I created a db <10
GB in size from a source db ~600Gb in a few minutes.

https://github.com/mla/pg_sample

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2011-08-25 00:43:34 Re: pg_restore --no-post-data and --post-data-only
Previous Message Alvaro Herrera 2011-08-24 21:48:37 Re: SSI 2PC coverage