On 2/23/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> On friday we upgraded a critical backend server to postgresql 8.2
> running on fedora core 4.
Umm ... why that particular choice of OS? Red Hat dropped update
support for FC4 some time ago, and AFAIK the Fedora Legacy project
is not getting things done. How old is the kernel you're using?
Linux mojo 2.6.17-1.2142_FC4smp #1 SMP Tue Jul 11 22:57:02 EDT 2006
i686 i686 i386 GNU/Linux
Unfortunately, the decision about which kernel to run is more or less
out of my hands. I would personally really dislike fedora and would
much prefer to be running centos/redhat as. That said, your comments
and those of others are very helpul in regards to fixing that.
we tried update to the latest via yum update with no help.
as promised, here is the best photo of the panic we could get:
We did an emergency downgrade to 8.1 and will monitor the
situation...the decision to get a new server has already been made and
hopefully it will be on a more stable platform.
big thanks to all who took a few minutes out of their day to lend a hand.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not