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.


Reply via email to