From: Bill Brandt <brandtwr-pgsql@draaw.net>
To: pgsql-sql@hub.org
Subject: question about pg_dump
Date: Tue, 2 Mar 1999 22:01:56 -0500
Message-ID: <19990302220156.A30158@draaw.net> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: brandtwr-pgsql@draaw.net, pgsql-sql@hub.org
Subject: Re: question about pg_dump
In-Reply-To: <19990302220156.A30158@draaw.net>
References: <19990302220156.A30158@draaw.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox