Re: Restore is failing

2020-02-05 Thread Adrian Klaver
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 y

Re: Restore is failing

2020-02-05 Thread Peter J. Holzer
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

Re: Restore is failing

2020-02-05 Thread Sonam Sharma
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 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 >

Re: Restore is failing

2020-02-05 Thread Rob Sargent
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 a

Restore is failing

2020-02-05 Thread Sonam Sharma
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 exi