Project

General

Profile

  • svn:executable: *

# Date Author Comment
13161 04/17/2014 02:51 PM Aaron Marcuse-Kubitza

lib/sh/db.sh pg_dump(), bin/pg_dump_vegbien: --format: use the long form of the formats to make the code self-documenting

12041 02/05/2014 12:55 AM Aaron Marcuse-Kubitza

bugfix: bin/pg_dump_vegbien: fixed arg-count check to allow passing command-line options to pg_dump via args

11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

7022 12/21/2012 03:33 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Renamed $opts env var to $dump_opts to avoid conflicting with other commands' vars of the same name

6338 11/20/2012 07:57 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: non-$owners mode: Removed --no-privileges in order to include GRANTs to other users

6038 11/06/2012 04:06 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: When not in data mode, use --inserts so the INSERT statements generated can be run directly in pgAdmin, they can be directly translated to MySQL, and an empty COPY FROM statement isn't generated for every table

6028 11/06/2012 01:47 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Except in (raw) data mode, filter out pg_catalog.setval() statements (only lookup table contents should be preserved)

6025 11/06/2012 01:18 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: $schema flag defaults to on to export only schema

6024 11/06/2012 01:08 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Fixed bug where schema name var can't be named $schema because that would conflict with the $schema flag

6022 11/06/2012 12:33 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Only include just the schema if new $schema flag is set. This causes constant lookup tables to automatically be exported for DB schemas, which was not fully supported by the $data flag because it also forced $owners to be enabled.

5672 10/19/2012 03:45 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Added opts env var to allow specifying options to a Makefile command, which does not take positional arguments

3430 07/17/2012 10:17 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Don't use SET SESSION AUTHORIZATION because it doesn't work with the py_functions schema (it requires PL/Python functions to be created as user postgres and then the owner changed to bien, which SET SESSION AUTHORIZATION won't do)

3406 07/16/2012 08:22 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: If first arg is "all", dump entire DB. Require a first arg so that Usage message will be displayed if run with no args.

3405 07/16/2012 08:03 PM Aaron Marcuse-Kubitza

Always output Usage messages to stderr and word-wrap them using `fold -s`

3401 07/16/2012 06:35 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: For consistency with setting the --schema option, use `set -- "$" args...` to append options to $ which are then passed to pg_dump, instead of specifying several variables which are then included in the pg_dump command

3400 07/16/2012 06:26 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Pass command line options directly to pg_dump after parsing out any schema name

3397 07/16/2012 05:14 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Save owners when saving data (for full export)

3396 07/16/2012 05:03 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Use SET SESSION AUTHORIZATION to ensure that owners are always recorded in the same format. This will help make plain text backups comparable using diff.

3388 07/13/2012 04:37 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Added plain env var which creates plain text output instead, for use in debugging and validation

3361 07/12/2012 02:34 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Added data option for backing up an import's schema

3251 07/06/2012 02:33 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: Enclose the schema name in "" because pg_dump requires this for schema names with special characters

2628 06/05/2012 10:49 AM Aaron Marcuse-Kubitza

pg_dump_vegbien: Fixed bug where needed space before $noOwners options

2626 06/05/2012 10:26 AM Aaron Marcuse-Kubitza

pg_dump_vegbien: Log the pg_dump command being run

2622 06/05/2012 10:15 AM Aaron Marcuse-Kubitza

pg_dump_vegbien: Support optionally including owners

2092 05/07/2012 06:41 PM Aaron Marcuse-Kubitza

Added pg_dump_vegbien to dump a schema of the vegbien db