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.