pg_dump error
От | Joe Conway |
---|---|
Тема | pg_dump error |
Дата | |
Msg-id | 004501bfa819$60237b10$0505a8c0@jec-nt1.elcjn1.sdca.home.com обсуждение исходный текст |
Список | pgsql-admin |
Hello, I am getting the following error when trying to use pg_dump: ******************************************************************* pg_dump cymi > cymi.2000_04_16.dmp FATAL 1: Memory exhausted in AllocSetAlloc() PQendcopy: resetting connection SQL query to dump the contents of Table 'cymi_det_arc_01' did not execute correctly. After we read all the table contents from the backend, PQendcopy() failed. Explanation from backend: 'FATAL 1: Memory exhausted in AllocSetAlloc() '. The query was: 'COPY "cymi_det_arc_01" TO stdout; ******************************************************************* The table it is failing on is about 77MB in size, about 1 million tuples. The server is dual pentium pro 200, with 512 MB RAM. I'm running PostgreSQL 6.5.2 on RedHat Linux 6.1, 686 SMP kernel. The kernel was recompiled per Oracle's optimization recommendations for the Linux version of 8i (shared memory and semaphore parameters, I can list if anyone feels it is relevant). I tried starting the postmaster with -B10000, -B25000, and -B not there (i.e. using default buffers). Same error in all three cases. Any help or suggestions would be appreciated. Thanks, Joe
В списке pgsql-admin по дате отправления: