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