Hi, all
I dumped a table using pg_dump, and then tried to import it into a new
database. Of the ~210,000 records in the original table, only about 193,000
were loaded, and the remainder caused an error: something about the query
buffer being too small. Now, I know that queries are limited in size, due
to the size of the query buffer, but none of these insert queries are longer
than about 600 characters. Is it possible that the stream from the dump
file is causing the buffer to overflow by simply overloading it with
incoming queries, and if so, how do I prevent this? If not, then does
anybody have any idea what the problem is.
The system is a 486 with 36MB of RAM running Red Hat 5.2, PostgreSQL 6.5,
started with: 'postmaster -i -B 1024 -S'.
Thanks...
MikeA
--------------------------------------------------------------------
Science is the game we play with God to find out what his rules are.
--------------------------------------------------------------------
