Search Postgresql Archives

Re: fine tuned database dump/reload?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux