Re: server closed the connection unexpectedly

Hi Mike:

Thanks for your answer, I'm unable to dump the table:

-bash-2.05b$ pg_dump -Fc -t afected_table database_name -f
./afected_table.dump
pg_dump: connection not open
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "afected_table"
failed: PQendcopy() failed.
pg_dump: Error message from server: FATAL 1:  The database system is
starting up


Ruben.


mike g wrote:
> 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
>