Postgres Pro
Downloads
Home   >   mailing lists

pg_dump on large columns - Mailing list pgsql-general

From Adam Siegel
Subject pg_dump on large columns
Date
Msg-id 1034776871.1053.10.camel@localhost.localdomain
Whole thread Raw
List pgsql-general
Tree view 
I have a table with several columns, including a text column.  It has
about 100 records.  The text column general contains about 5MB of ascii
data that is escaped per record.  pg_dump goes fine.  However when I do
a psql -f dumpfile, postgres just spins it wheels and never finishes the
restore.  The text was inserted into the table using the PQ API by
building an sql statement and using PQexec.  Selects from the table work
just fine.  Any thoughts would be appreciated.  I am using 7.2.

pgsql-general by date:

Previous
From: "Robert John Shepherd"
Date:
Subject: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat"
Next
From: Tom Lane
Date:
Subject: Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat"