Hello everybody,
This question has appeared in mailing list yet but nobody
answered it... However I hope
that somebody knows what's the reason.
I am upgrading PostgreSQL 6.3.2 to PostgreSQL 6.4.2. I had no
problems with
compiling. Before it I've made dump of my database using
pg_dumpall of 6.3.2:
pg_dumpall -z >db.out
But when I tried to load my database to 6.4.2 using command:
psql -e template1<db.out
I've got the following messages that repeated many, many times
while a COPY command
was being executed:
query buffer max length of 20000 exceeded
query line ignored
and
Segmentation fault (core dumped)
at the end of output.
Then I tried to use the pg_dumpall of 6.4.2 for dumping, when the
postmaster of 6.3.2 was
running ( as recommended in INSTALL file for earlier versions).
But after the same
loading of my database I 've got the same messages about query
buffer max length of 20000
exceeded... After that I 've even made the dump of only one
table of database for
experiement. But after command:
psql -e my.database< table.database.out
the moving was unsuccessfull with the same messages...
I use FreeBSD 3.0.
I think it's a bug of 6.4.2. Can anybody help me ?
Thanks in advance.
Jane Bulakh.