question about pg_dump - Mailing list pgsql-sql

From Bill Brandt
Subject question about pg_dump
Date
Msg-id 19990302220156.A30158@draaw.net
Whole thread Raw
List pgsql-sql
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/

pgsql-sql by date:

Previous
From: mueller@pmsun20.dial.eunet.ch (Pascal Mueller)
Date:
Subject: RULE problem
Next
From:
Date:
Subject: Undeliverable Message