Re: server closed the connection unexpectedly

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