pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
question about pg_dump
2+ messages / 2 participants
[nested] [flat]

* question about pg_dump
@ 1999-03-03 03:01  Bill Brandt <brandtwr-pgsql@draaw.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Bill Brandt @ 1999-03-03 03:01 UTC (permalink / raw)
  To: pgsql-sql@hub.org

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: question about pg_dump
@ 1999-03-03 15:25  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 1999-03-03 15:25 UTC (permalink / raw)
  To: pgsql-sql@hub.org

Bill Brandt <brandtwr-pgsql@draaw.net> writes:
> 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?

You can just split the command into sections by editing the dump file
(assuming you have an editor that will cope ;-)):

	COPY table FROM stdin;
	blah blah
	blah blah
	\.
	COPY table FROM stdin;
	more more
	more more
	\.

COPY is really APPEND, it doesn't delete any tuples that were there,
so this should work.

Still, a 20K-line limit sounds awfully brain-dead to me.  And a quick
look at the source code (both 6.4.2 and current CVS) doesn't show any
such check unless I missed something.  What version are you using?
What's the exact text of the error message?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-03-03 15:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-03 03:01 question about pg_dump Bill Brandt <brandtwr-pgsql@draaw.net>
1999-03-03 15:25 Re: question about pg_dump Tom Lane <tgl@sss.pgh.pa.us>

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