Version is 11.2 .. took schema dump using pg_dump -d -n (schma) / gunzip ..
The error I am getting while running restore. On Wed, Feb 5, 2020, 2:03 PM Rob Sargent <robjsarg...@gmail.com> wrote: > > > 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. > >
