| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
| Cc: | Alejandro Carrillo <fasterzip(at)yahoo(dot)es>, Hellmuth Vargas <hivs77(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [pgsql-es-ayuda] como exportar separado por comas una tabla grande |
| Date: | 2012-10-24 18:44:27 |
| Message-ID: | 20121024184427.GF6853@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Perales M. | 2012-10-24 18:49:51 | Re: Exportar e importar Base de Datos |
| Previous Message | Hellmuth Vargas | 2012-10-24 18:36:55 | Re: [pgsql-es-ayuda] como exportar separado por comas una tabla grande |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eliot Gable | 2012-10-24 19:57:43 | Disable autovacuum on specific tables |
| Previous Message | Hellmuth Vargas | 2012-10-24 18:36:55 | Re: [pgsql-es-ayuda] como exportar separado por comas una tabla grande |