|
Even without saving to file, it is still
killed: Welcome to psql 8.0.3, the PostgreSQL
interactive terminal. Type: \copyright for distribution
terms \h
for help with SQL commands \?
for help with psql commands \g or
terminate with semicolon to execute query \q to
quit My_db=# select * from a_table; Killed bash-2.05b$ PG log shows: could not send data to client: Connection
reset by peer could not send data to client: Broken pipe unexpected EOF on client connection Can anyone help? Thanks, PS: psql launched from the same PG server
box. From: Lee Wu Hi, When I try to save a query result into a text file from
“select * from a_table”, once I got: out of memory for query result under psql Once got killed: My_db=# select * from a_table; Killed bash-2.05b$ And once it caused PG crashed. My PG version is: select version();
version ---------------------------------------------------------------------------------------------------------- PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC
gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-49) (1 row) The table has 6287585 rows, and takes 2805000 bytes. From the PG log, I can only find: could not send data to client: Connection reset by peer could not send data to client: Broken pipe unexpected EOF on client connection How can I save PG data into text file without using pg_dump? Thanks, PS: I know pg_dump, but it is not my option. |
- Re: [ADMIN] select * and save into a text file failed Lee Wu
