From: | marcosrios(at)planet(dot)com(dot)pe |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Por favor, ayuda con Error en Backup |
Date: | 2007-10-18 14:10:00 |
Message-ID: | 20071018091000.7m774zlc848kws04@webmail.planet.com.pe |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola amigos,
Tengo un problema que no se como solucionar. Tengo instalado
Postgresql8.1.4 sobre Open SUSE Linux 10. Intento sacar un backup a un
base de datos por medio del PgAdmin1.8.0 RC1 y me arroja este error:
************************************
...
pg_dump: dumping contents of table detalle_pedidos
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid memory alloc
request size 4294967292
pg_dump: The command was: COPY public.detalle_pedidos (empresa,
sucursal, pedido, codbar, cod_producto, cantidad, precio_unitario,
valor_venta, tasa_dscto, dscto, impuestos, total_venta, procesado,
anulado) TO stdout;
pg_dump: *** aborted because of error
Process returned exit code 1
************************************
Le hice un vacumm a esa tabla (detalle_pedidos) y la pasa sin
problemas, esta tabla contiene poco mas de 5 millones de registros que
son muy importantes.
Intente sacarle un backup individual a esa tabla y me arroja el
siguiente error:
*************************
C:\Archivos de programa\pgAdmin III\1.8\pg_dump.exe -i -h 192.168.0.2
-p 5432 -U postgres -F c -v -f
"D:\IntegralSQL\detalle_pedidos16102007.backup" -t
"\"public\".\"detalle_pedidos\"" integral
pg_dump: reading schemas
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined operator families
pg_dump: reading user-defined conversions
pg_dump: reading user-defined tables
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: reading type casts
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "detalle_pedidos"
pg_dump: finding default expressions of table "detalle_pedidos"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "detalle_pedidos"
pg_dump: reading constraints
pg_dump: reading triggers
pg_dump: reading dependency data
pg_dump: saving encoding = LATIN1
pg_dump: saving standard_conforming_strings = off
pg_dump: dumping contents of table detalle_pedidos
pg_dump: Dumping the contents of table "detalle_pedidos" failed:
PQgetCopyData() failed.
pg_dump: Error message from server: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: The command was: COPY public.detalle_pedidos (empresa,
sucursal, pedido, codbar, cod_producto, cantidad, precio_unitario,
valor_venta, tasa_dscto, dscto, impuestos, total_venta, procesado,
anulado) TO stdout;
pg_dump: *** aborted because of error
Process returned exit code 1.
*********************************
Por favor, les agradecere mucho cualquier sugerencia y sobre todo
saber a que se debe ese error?
Marcos T. Rios Rodriguez
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-10-18 14:21:21 | Re: Por favor, ayuda con Error en Backup |
Previous Message | Arturo Munive [pgsql-es-ayuda] | 2007-10-18 14:00:08 | Re: usuarios novatos |