Re: fine tuned database dump/reload? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: fine tuned database dump/reload?
Date
Msg-id 200510121403.j9CE3Wm11441@candle.pha.pa.us
Whole thread Raw
In response to Re: fine tuned database dump/reload?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
List pgsql-general
The TODO has has an open item to all multiple -t options and other
complexity.


---------------------------------------------------------------------------

Dan Armbrust wrote:
> Dan Armbrust wrote:
> > Bricklen Anderson wrote:
> >
> >>
> >> pg_dump --help
> >> ...
> >>   -n, --schema=SCHEMA      dump the named schema only
> >>   -s, --schema-only        dump only the schema, no data
> >>   -t, --table=TABLE        dump the named table only
> >> ...
> >>
> >
> > Just after I sent the e-mail, I realized that I forgot that I saw that
> > option - but on my first reading of the description (and being and
> > annoying user who didn't try it first) it didn't appear that it would
> > allow me to specify more than one table.
> >
> > But I tested it, and it does let me specify the -t command more than
> > once.  So that gets me past that issue.
> >
> > Dan
> >
> >
> Now I'm just filling the mailing list with mis-information.  It actually
> ignores all but the last -t flag - so this only allows me to specify one
> table at a time, rather than several tables.
>
> I need to write up my use case so the maintainers can see why I want to
> be able to dump things in such a specific way - its not for backup
> purposes - so I'm kind of misusing the intent of the tool.  More info in
> a bit.
>
> Dan
>
>
>
> --
> ****************************
> Daniel Armbrust
> Biomedical Informatics
> Mayo Clinic Rochester
> daniel.armbrust(at)mayo.edu
> http://informatics.mayo.edu/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Ron Mayer
Date:
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?
Next
From: Ned Lilly
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase