Re: Restore is failing

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 2/5/20 12:47 AM, Sonam Sharma wrote:
> Version is 11.2 .. took schema dump using pg_dump -d -n (schma) / gunzip ..

So the above was a plain text dump that you then piped through 
gunzip(?)? That does not make sense.
> The error I am getting while running restore.

If it is a plain text dump you would need to use psql not pg_restore.

> On Wed, Feb 5, 2020, 2:03 PM Rob Sargent <robjsargent@xxxxxxxxx 
> <mailto:robjsargent@xxxxxxxxx>> 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.


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx