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 <[email protected] <mailto:[email protected]>> 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 , SonamWhat version of postgres? Method of copy? Identify which server process is failing, what's the error there.
-- Adrian Klaver [email protected]
