How to fix lost synchronization with server - Mailing list pgsql-general

From Andrus
Subject How to fix lost synchronization with server
Date
Msg-id 5B34FED77EE547FF99499D273366964B@dell2
Whole thread Raw
In response to Re: How to add xml data to table  ("Francisco Figueiredo Jr." <francisco@npgsql.org>)
Responses Re: How to fix lost synchronization with server
List pgsql-general
After upgrading server to Postgres 9.3 in Debian customer cannot create
backups anymore. pg_dump returns
error lost synchronization with server:

"C:\myapp\..\pg_dump\pg_dump.exe" -ib -Z3 -f "C:\mybackup.backup" -Fc -h
1.2.3.4 -U user -p 5432 mydb

pg_dump: Dumping the contents of table "attachme" failed: PQgetCopyData()
failed.
pg_dump: Error message from server: lost synchronization with server: got
message type "d", length 5858454
pg_dump: The command was: COPY firma1.attachme (id, idmailbox, attachname,
attachbody, attachtype) TO stdout;


attachme table contains 4487 records
Its  total size is 1016 MB. Most data is contained in one bytea column

I changed

ssl_renegotiation_limit = 512GB

in postgresql.conf but problem persists.

postgres log file does not contain any information about this.

How to fix or diagnose the issue ?

Should I

1. Add --inserts line option to pg_dump. According to (1) it fixes the
issue.
2. Turn ssl off
3. Change something in VMWare . According to (1) it occurs in VMWare only


Server:

PostgreSQL 9.3.3 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.2-5) 4.7.2, 64-bit
Debian Linux x64 is running under VMWare, 2 cores

Apache and Mono 3.2.8 with mod_mono MVC4 applicati is also running in this
server


Client:

Windows computer running 9.3 pg_dump.exe over in LAN but external IP address
(1.2.3.4) is used


It worked if server was Widows 2003 server running earlier Postgres 9
without SSL.


Andrus.

(1) https://groups.google.com/forum/#!topic/pgsql.bugs/-bS1Lba3txA



pgsql-general by date:

Previous
From: Leif Jensen
Date:
Subject: Re: Server process crash - Segmentation fault
Next
From: Tom Lane
Date:
Subject: Re: Server process crash - Segmentation fault