Received: from draaw.net (qmailr@puma.draaw.net [199.234.237.21]) by hub.org (8.9.2/8.9.1) with SMTP id WAA37578 for ; Tue, 2 Mar 1999 22:01:59 -0500 (EST) (envelope-from bbrandt@draaw.net) Received: (qmail 30237 invoked by uid 501); 3 Mar 1999 03:01:56 -0000 Date: Tue, 2 Mar 1999 22:01:56 -0500 From: Bill Brandt To: pgsql-sql@hub.org Subject: question about pg_dump Message-ID: <19990302220156.A30158@draaw.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95us I'm trying to upgrade from 6.3. In doing this, I performed a pg_dump of each database (pg_dump -o where the oid's matter). I have one database (which doesn't use oid info in the tables btw) that is around 40MB of data. The output file that created looks fine, but when I go to load the data, it gets a portion of the way into loading and indicates that you cannot exceed 20000 lines of input on a copy command. Is there a way to dump the database that it won't try more than 20000 lines at a time? I kept the 6.3 directory so dumping again is not a big deal. Bill -- Bill Brandt brandtwr@draaw.net http://www.draaw.net/