Skip site navigation (1) Skip section navigation (2)

Re: A crashing query

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: A crashing query
Date: 2001-03-28 12:44:11
Message-ID: slrn9c3n4r.cec.jdassen@odin.cistron-office.nl (view raw or flat)
Thread:
Lists: pgsql-admin
Mario Jorge Nunes Filipe <mjnf(at)uevora(dot)pt> wrote:
>We're running several PostgreSQL databases in several different servers
>(also with different PG versions :( ).
>
>In one of our on-line systems we connect to the "local" database and a
>"remote" database. The connection to the remote database was always ok,
>without any kind of problems, but yesterday, out of the blue, one of the
>query's (the most important one) started to crash the remote server.

Are you sure you're running a client that's the same PostgreSQL version as
the server?

>this system is a 6.4.2, it was vacuumed and it crashes, violently...
>Does anyone have a clue of why?

Even users running 6.5 are usually advised to upgrade to a 7.x release when
they run into crashes. 6.4 is old.

HTH,
Ray
-- 
Pinky, Are You Pondering What I'm Pondering?
I think so Brain, but "instant karma" always gets so lumpy. 
	Pinky and the Brain in "Brainwashed Part 3: Wash Harder"


In response to

pgsql-admin by date

Next:From: Trewern, BenDate: 2001-03-28 12:50:54
Subject: RE: date_part bug?
Previous:From: agichenDate: 2001-03-28 12:07:31
Subject: pg_dump ERROR .......

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group