gonymizer icon indicating copy to clipboard operation
gonymizer copied to clipboard

Wrap pg_dump's ability to dump only a few tables

Open GuillaumeRossolini opened this issue 4 years ago • 1 comments

Hi,

Conversely to the ability to exclude tables from the dump, which gonymizer already wraps, pg_dump also has the ability to specify exactly which tables should be exported:

  -t, --table=TABLE            dump the named table(s) only

This would be nice at the prototyping phase with gonymizer: just focus on a few tables, don't wait too much on the network.

Cheers

GuillaumeRossolini avatar Sep 09 '20 15:09 GuillaumeRossolini

Workaround for users in the meantime:

  1. use --log-level=DEBUG for a first run with gonymizer dump;
  2. keep a record of the pg_dump command line with all the options, and feel free to stop the container;
  3. update your script to use this pg_dump command instead of the usual gonymizer dump, and add the --table options as needed.

GuillaumeRossolini avatar Sep 17 '20 09:09 GuillaumeRossolini

Ended up using a different solution.

GuillaumeRossolini avatar Jun 30 '23 20:06 GuillaumeRossolini