why my postgresql auto crashed???

hi, all
when I do the command from a sql file by psql client,
I got the message:
----
psql:/home/zhay/insert.sql:8: server closed the
connection unexpectedly
        This probably means the server terminated
abnormally
        before or while processing the request.
psql:/home/zhay/insert.sql:8: connection to server was
lost
----
my sql file is :
set search_path to lives;

insert into store_all select c.*, z.t from  (
        select b.*, y.t from (
                select a.*,  x.t from store a
                        left join (select pid,
array_to_string(array_accum(anchor), ' ') as t
from recommend group by pid)x on x.pid = a.id
        )b left join (select pid,
array_to_string(array_accum(anchor), ' ') as
t from tag group by pid)y on y.pid = b.id
)c left join (select pid,
array_to_string(array_accum(anchor), ' ') as t
from categorie group by pid)z on z.pid = c.id;



so, I check the pg_log
------------
LOG:  server process (PID 4121) was terminated by
signal 6: Aborted
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  The postmaster has commanded this server
process to roll back
the current transaction and exit, because another
server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  The postmaster has commanded this server
process to roll back
the current transaction and exit, because another
server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  The postmaster has commanded this server
process to roll back
the current transaction and exit, because another
server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  The postmaster has commanded this server
process to roll back
the current transaction and exit, because another
server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  The postmaster has commanded this server
process to roll back
the current transaction and exit, because another
server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up
at 2008-07-27
07:36:16 UTC
LOG:  database system was not properly shut down;
automatic recovery in
progress
FATAL:  the database system is in recovery mode
LOG:  redo starts at D/3FB00BC0
LOG:  record with zero length at D/3FB59898
LOG:  redo done at D/3FB59868
LOG:  last completed transaction was at log time
2008-07-27
07:40:53.70866+00
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
------------

thanks all.

regards.



      ___________________________________________________________
 雅虎邮箱，您的终生邮箱！
http://cn.mail.yahoo.com/