Re: [HACKERS] pg_dump not dumping all tables - Mailing list pgsql-hackers

From Ross J. Reedstrom
Subject Re: [HACKERS] pg_dump not dumping all tables
Date
Msg-id 19990728225411.A27499@wallace.ece.rice.edu
Whole thread Raw
In response to Re: [HACKERS] pg_dump not dumping all tables  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
On Wed, Jul 28, 1999 at 11:28:17PM -0300, The Hermit Hacker wrote:
> On Wed, 28 Jul 1999, G. Anthony Reina wrote:
> 
> > Again, the text file is over 2 Gig so I can't seem to find an editor that is
> > big enough to hold it all in memory (I only have a half a gig of RAM). So it
> > really is just guesswork. Anything you can think of to strip the data from
> > this big of a file?
> 
> egrep "^CREATE|^COPY" <filename> ?

The one class of failures on upgrade we have been seeing is tables with
fieldnames that were previously reserved words. One of those might keep the
rest of the COPYs from working, would it not?

try piping the combined stdout and stderr together through grep "ERROR"
and see if anything pops up.

Ross

-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
Next
From: Thomas Lockhart
Date:
Subject: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)