Error en Backup

From: marcosrios(at)planet(dot)com(dot)pe
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Error en Backup
Date: 2007-10-17 15:44:04
Message-ID: 20071017104404.ev0rjvpjacok4cc4@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_orco_cont
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.
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
Arequipa - Peru

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message José Fermín Francisco Ferreras 2007-10-17 16:25:48 usuarios novatos
Previous Message Alvaro Herrera 2007-10-17 13:56:14 Re: Carga de Datos en Postgresql