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.