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

Re: Incomplete pg_dump operation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: peter(at)vfemail(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Incomplete pg_dump operation
Date: 2010-02-08 15:37:56
Message-ID: 10623.1265643476@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
peter(at)vfemail(dot)net writes:
> The first execution of the:

>      select * from pg_index where indexrelid = 2196359751;

> command returned this message:

>      WARNING:  terminating connection because of crash of another server process

It seems you have much worse problems than this one table.  I think you
need to plan on re-initdb'ing and re-loading.  If you can't get pg_dump
to produce a whole dump, does it work to dump one table at a time with
the -t switch?

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-02-08 15:49:49
Subject: Re: trouble with an older version of postgresql
Previous:From: Joshua TolleyDate: 2010-02-08 14:02:30
Subject: Re: trouble with an older version of postgresql

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