server closed the connection unexpectedly

From: Rafael Valenzuela <ravamo(at)gmail(dot)com>
To: Ayuda Esp PostgreSQL <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: server closed the connection unexpectedly
Date: 2020-05-30 19:19:39
Message-ID: CAKqsoo+eFPazAwB7p5doEZXdwGi16PtWJX5UnHc7oBfbuWSwhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Buenas !
Ultimamente me esta saliendo este error al exportar unas tablas mediante un
copy
COPY data transfer failed: server closed the connection unexpectedly This
probably means the server terminated abnormally before or while processing
the request. server closed the connection unexpectedly This probably means
the server terminated abnormally before or while processing the request.

He estado mirando a ver que puede ser pero ando algo perdido he comprobado
los siguientes flags que por lo que he visto tiene algo que ver con la
exportanción.

- shared_buffers=>2492MB
- temp_file_limit=>10268767kB.

El volumen de las tablas son aproximadamente de 30GB y 15GB , he buscado
por internet y solo he visto este link
<https://community.pivotal.io/s/article/gpinitstandby-Fails-with-Error-pgbasebackup-could-not-read-COPY-data-server-closed-the-connection-unexpectedly-due-to-Lack-of-Disk-Space?language=en_US>
pero
no tengo muy claro por donde tirar .

Lo tengo montando en Google cloud

- vCPU=>2
- Memoria=>7,5 GB
- Almacenamiento: SSD=>109 GB
- PG 9.6

Alguna idea?
Saludos

{ name : "Rafael Valenzuela",

open source : ["Saiku Admin Console","Anaytical Sport"],

location : "Madrid Spain",

twitter : ["@sowe <https://twitter.com/sowe>"] ,

linkedin : profile
<http://es.linkedin.com/pub/rafael-valenzuela/19/694/61a/> ,
phone : 0034649884067

}

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Martín Marqués 2020-06-01 11:31:21 Re: server closed the connection unexpectedly
Previous Message Hellmuth Vargas 2020-05-28 17:18:29 prueba de jit en postgres 11