Hi all

First, many thanks to all who helped with my crashes probs. Not fixed yet
but has been analyzed as a need to upgrade the BIOS.

Then as I said before, I have this problem with stats buffer I know have a
phantoom query:

Script started on Sun Feb  1 20:05:56 2004
~ 20:05:56: psql
Welcome to psql 7.4.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

ohp=# SELECT * from pg_stat_activity ;
 datid | datname  | procpid | usesysid | usename  |                                                                              current_query                                                                              |             query_start
-------+----------+---------+----------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------
 38920 | sdewitte |   27575 |    60004 | sdewitte | <IDLE>                                                                                                                                                                  | Sun 01 Feb 20:06:01.867356 2004 MET
 38920 | sdewitte |   27577 |    60004 | sdewitte | select lieu_cod from lieu_position,perso_position,lieu where ppos_perso_cod = 41980 and ppos_pos_cod = lpos_pos_cod and lpos_lieu_cod = lieu_cod and lieu_refuge = 'O'  | Sun 01 Feb 20:06:01.868747 2004 MET
 38920 | sdewitte |    6518 |    60004 | sdewitte | select count(*) from perso_identifie_objet where pio_perso_cod = 53314 and pio_obj_cod = 28204                                                                          | Sun 01 Feb 18:30:37.835876 2004 MET
 38915 | ohp      |   27574 |      101 | ohp      | <IDLE>                                                                                                                                                                  | Sun 01 Feb 20:06:00.472581 2004 MET
(4 rows)

ohp=# \q
~ 20:06:04: exit

script done on Sun Feb  1 20:06:04 2004
Feb  1 18:31:02 server postgres[1759]: [61-1] LOG:  statistics buffer is full
Feb  1 18:31:06 server postgres[6658]: [23-1] LOG:  recycled transaction log file "0000000A00000014"
Feb  1 18:31:40 server postgres[6868]: [23-1] LOG:  duration: 5298.605 ms  statement: VACUUM ANALYZE "public"."perso"
Feb  1 18:31:41 server postgres[6891]: [23-1] LOG:  duration: 2350.284 ms  statement: update perso set perso_der_connex = now() where perso_cod = 30245
Feb  1 18:31:42 server postgres[6868]: [24-1] LOG:  duration: 2438.490 ms  statement: VACUUM ANALYZE "public"."sessions_log"
Feb  1 18:31:45 server postgres[6888]: [23-1] LOG:  recycled transaction log file "0000000A00000015"
Feb  1 18:31:45 server postgres[6888]: [24-1] LOG:  recycled transaction log file "0000000A00000016"

As you can see, there was a stat buffer full at 18:31 and the process 6518
no longer exists but still shows up in pg_stat_activity.

How can I get rid of it short of restarting postgresql?

Regards,
-- 
Olivier PRENANT        	        Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

Sun, 1 Feb 2004 20:11:03 +0100 (MET)
ohp@pyrenet.fr
how can I get read of that