Re: [pgsql-es-ayuda] como exportar separado por comas una tabla grande - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: [pgsql-es-ayuda] como exportar separado por comas una tabla grande
Date
Msg-id 20121024184427.GF6853@alvh.no-ip.org
Whole thread Raw
In response to Re: [pgsql-es-ayuda] como exportar separado por comas una tabla grande  (Moshe Jacobson <moshe@neadwerx.com>)
List pgsql-general
> > data=#  \o /tmp/datos_para_proceso.csv
> > data=# select * from datos_para_proceso;
> > /opt/PostgreSQL/9.2/bin/psql: lí­nea 30:  9608 Terminado (killed)
> >  LD_PRELOAD=$PLL LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PG_BIN_PATH/../lib
> > "$PG_BIN_PATH/psql.bin" "$@"

Moshe Jacobson escribió:
> More important than the solution to this specific problem is the question
> of why psql crashed when doing this export...

I bet the OP can find an OOM-killer report in syslog.


--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Hellmuth Vargas
Date:
Subject: Re: [pgsql-es-ayuda] como exportar separado por comas una tabla grande
Next
From: Eliot Gable
Date:
Subject: Disable autovacuum on specific tables