Re: Restore is failing - Mailing list pgsql-general

From Rob Sargent
Subject Re: Restore is failing
Date
Msg-id b60c65d5-c24f-0148-c307-8d7e894bbd9a@gmail.com
Whole thread Raw
In response to Restore is failing  (Sonam Sharma <sonams1209@gmail.com>)
Responses Re: Restore is failing  (Sonam Sharma <sonams1209@gmail.com>)
List pgsql-general


On 2/5/20 1:24 AM, Sonam Sharma wrote:
I am copying schema data to qa box from prod.its failing and giving below error :

WARNING:  terminating connection because of crash of another server process

DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

HINT:  In a moment you should be able to reconnect to the database and repeat your command.

server closed the connection unexpectedly. 


Can some one please help. Work_mem is set to 8gb. 


Thanks , Sonam

What version of postgres?
Method of copy?
Identify which server process is failing, what's the error there.

pgsql-general by date:

Previous
From: Sonam Sharma
Date:
Subject: Restore is failing
Next
From: Sonam Sharma
Date:
Subject: Re: Restore is failing