Re: Restore is failing - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Restore is failing
Date
Msg-id 20200205104006.GA31182@hjp.at
Whole thread Raw
In response to Restore is failing  (Sonam Sharma <sonams1209@gmail.com>)
List pgsql-general
On 2020-02-05 13:54:56 +0530, 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.

As the message states, the problem is with another server process. You
need to identify that process and why it crashed. Check the postgres
server log. It should contain an error message. You might also want to
check the syslog (on Linux or other Unixes) or equivalent for system
errors (e.g. out of memory, disk errors, etc.)

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: "Satheesh-Gsuite"
Date:
Subject: Read: The best way to solve a problem
Next
From: Raul Kaubi
Date:
Subject: Get rid of brackets around variable