From: | mike g <mike(at)thegodshalls(dot)com> |
---|---|
To: | ruben <ruben20(at)superguai(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: server closed the connection unexpectedly |
Date: | 2004-07-06 02:50:52 |
Message-ID: | 1089082252.15115.2.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can you use pg_dump to backup the database and possibly then upgrade the
db? 7.2 is rather old. I recall reading similar postings in the
mailing this that recommend you upgrade to 7.2.4 or .6(?) if you must
stay on 7.2.
On Mon, 2004-07-05 at 17:48, ruben wrote:
> Hi:
>
> I'm getting this error when accessing a table with certain WHERE condition:
>
> "server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed."
>
> I've read through the posts but found no answer to the problem.
>
> When I "Vaccum analize" the table I get the same error.
>
> I have droped and re-created the indexes.
>
> Version is
> "PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2
> 20020903 (Red Hat Linux 8.0 3.2-7)"
>
> Any help on how to recover the table would be greatly appreciated.
> Thanks, Ruben.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-07-06 03:23:43 | Re: Multi-Language upper(),lower() |
Previous Message | Clodoaldo Pinto Neto | 2004-07-06 01:33:51 | could not access file "$libdir/plpython" when restoring |