Re: Restore is failing

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 <robjsargent(at)gmail(dot)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.
>
>