From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Sonam Sharma <sonams1209(at)gmail(dot)com>, Rob Sargent <robjsargent(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Restore is failing |
Date: | 2020-02-05 15:43:34 |
Message-ID: | b5326686-f666-9aab-0dff-40a670f374b9@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com
> <mailto: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.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Charley | 2020-02-05 17:15:07 | Re: Should I reinstall over current installation? |
Previous Message | Raul Kaubi | 2020-02-05 15:23:38 | Re: Error handling: Resume work after error |