Обсуждение: Postgres 6.4 load problem

Поиск
Список
Период
Сортировка

Postgres 6.4 load problem

От
Robert Adam II
Дата:
 Hi,
    I'm having a problem moving a database from 6.3.2 to 6.4

        Hardware:        Alpha
        OS:              Digital Unix 4.0d

        Dump command:    pg_dumpall -z >db.out
        Load command:    psql -e template1 <db.out

    I'm using the "pg_dumpall" command from 6.4 as suggested
    by the INSTALL file.

    Both the dump and load commands are done by the "postgres"
    account.

    When I try to load the database,  I eventually get the following
    message (many times) while a COPY command is being executed:
            query buffer max length of 20000 exceeded
            query line ignored

    I removed 6.4, reinstalled 6.3.2, and was able to do the load with
    no problem.

    Is this a bug or did I miss something?

 Thanks,
 Robert Adam, II