Re: FATAL: terminating connection because protocol synchronization was lost

On 10/16/18 8:36 AM, Shrikant Bhende wrote: Hi Adrian, Thanks for your reply. O/S is centos 6.7 on AWS EC2 , this is happening when system starts copying data for the biggest table, so just to reconfirm I have taken a pg_dump with Fp for that single table and tried to restore the same into PG

Re: FATAL: terminating connection because protocol synchronization was lost

Hi Adrian, Thanks for your reply. O/S is centos 6.7 on AWS EC2 , this is happening when system starts copying data for the biggest table, so just to reconfirm I have taken a pg_dump with Fp for that single table and tried to restore the same into PG cluster which was successful, and then again whe

Re: FATAL: terminating connection because protocol synchronization was lost

On 10/16/18 7:29 AM, Shrikant Bhende wrote: Hi Adrian, Its a PostgreSQL binary and installer was downloaded from enterprisedb site. Binary version : psql (PostgreSQL) 9.6.10 Command to restore the dump is : ./psql -p 5434 -d cloud -f Hmm. What OS is this? Does the error always happen in th

Re: FATAL: terminating connection because protocol synchronization was lost

Hi Adrian, Its a PostgreSQL binary and installer was downloaded from enterprisedb site. Binary version : psql (PostgreSQL) 9.6.10 Command to restore the dump is : ./psql -p 5434 -d cloud -f Thanks On Tue, Oct 16, 2018 at 2:55 AM Adrian Klaver wrote: > On 10/15/18 8:10 AM, Shrikant Bhende wro

Re: FATAL: terminating connection because protocol synchronization was lost

On 10/15/18 8:10 AM, Shrikant Bhende wrote: Hi Adrain, Its running on the local machine itself. I googled this around but most of the blog says that stop supporting the older version, also I took pg_dumpall from EDB PPAS cluster using PostgreSQL binaries, if that might have caused anything.

Re: FATAL: terminating connection because protocol synchronization was lost

Hi Adrain, Its running on the local machine itself. I googled this around but most of the blog says that stop supporting the older version, also I took pg_dumpall from EDB PPAS cluster using PostgreSQL binaries, if that might have caused anything. Thanks. On Mon, Oct 15, 2018 at 8:36 PM Adrian Kl

Re: FATAL: terminating connection because protocol synchronization was lost

On 10/15/18 8:04 AM, Shrikant Bhende wrote: Hi Adrian, There is no explicit client its just simple restore using psql with all default settings required. psql is the client. Where is it running relative to the server locally or remote? On Mon, Oct 15, 2018 at 6:50 PM Adrian Klaver

Re: FATAL: terminating connection because protocol synchronization was lost

Hi Adrian, There is no explicit client its just simple restore using psql with all default settings required. On Mon, Oct 15, 2018 at 6:50 PM Adrian Klaver wrote: > On 10/15/18 5:36 AM, Shrikant Bhende wrote: > > Hi Team, > > > > I am trying to restore the backup into postgresql 9.6 and during

Re: FATAL: terminating connection because protocol synchronization was lost

Shrikant Bhende writes: > I am trying to restore the backup into postgresql 9.6 and during restore > copy command fails with below error, > 2018-10-12 06:21:40 UTC [40407]: [28-1] > application=psql.bin,user=postgres,db=cloudLOG: could not send data to > client: Broken pipe This says the client

Re: FATAL: terminating connection because protocol synchronization was lost

On 10/15/18 5:36 AM, Shrikant Bhende wrote: Hi Team, I am trying to restore the backup into postgresql 9.6 and during restore copy command fails with below error, 2018-10-12 06:21:40 UTC [40407]: [28-1] application=psql.bin,user=postgres,db=cloudLOG:  could not send data to client: Broken p

FATAL: terminating connection because protocol synchronization was lost

Hi Team, I am trying to restore the backup into postgresql 9.6 and during restore copy command fails with below error, 2018-10-12 06:21:40 UTC [40407]: [28-1] application=psql.bin,user=postgres,db=cloudLOG: could not send data to client: Broken pipe 2018-10-12 06:21:40 UTC [40407]: [29-1] applic