postgres 8.1 crashing

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

postgres 8.1 crashing

Kari Lavikka


I just upgraded pg 8.0.3 to 8.1 (dump and reload) and outcome was a
corrupted database. pg 8.1 seemed to fly but backends were crashing

Hardware is Sun v40z with 64bit Debian Sarge, Linux Size of
database is somewhere around 500M rows and it's loaded by a website with a
lot of traffic.


Some backtraces (update queries are included in the bt):

And users-table which is involved in all the crashes is described
here (contains ~700000 rows):

I tried to reindex the table but it didn't help. PG went corrupted
after a while:

Any ideas?

     ( oo )    Kari Lavikka - [hidden email] - (050) 380 3808
__ooO(  )Ooo_______ _____ ___ _ _  _   _    _      _                  _

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings