BUG #5758: Error during backup - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      5758
Logged by:          Sunil Vedd
Email address:      sunil.ved@songas.com
PostgreSQL version: PostgreSQL 8.4
Operating system:   Windows 2003
Description:        Error during backup
Details:

Please let me know reason of error below when performing database backup.

C:\Program Files\pgAdmin III\1.10\pg_dumpall.exe --host localhost --port
5432 --username postgres --verbose --file "E:\Backup\Backup19112010.sql"
pg_dumpall: executing SET search_path = pg_catalog
pg_dumpall: executing SELECT rolname, rolsuper, rolinherit, rolcreaterole,
rolcreatedb, rolcatupdate, rolcanlogin, rolconnlimit, rolpassword,
rolvaliduntil, pg_catalog.shobj_description(oid, 'pg_authid') as rolcomment
FROM pg_authid ORDER BY 1
pg_dumpall: executing SELECT rolconfig[1] FROM pg_authid WHERE rolname =
'postgres'
pg_dumpall: executing SELECT rolconfig[1] FROM pg_authid WHERE rolname =
'songas'
pg_dumpall: executing SELECT ur.rolname AS roleid, um.rolname AS member,
a.admin_option, ug.rolname AS grantor FROM pg_auth_members a LEFT JOIN
pg_authid ur on ur.oid = a.roleid LEFT JOIN pg_authid um on um.oid =
a.member LEFT JOIN pg_authid ug on ug.oid = a.grantor ORDER BY 1,2,3
pg_dumpall: executing SELECT spcname, pg_catalog.pg_get_userbyid(spcowner)
AS spcowner, spclocation, spcacl, pg_catalog.shobj_description(oid,
'pg_tablespace') FROM pg_catalog.pg_tablespace WHERE spcname !~ '^pg_' ORDER
BY 1
pg_dumpall: executing SELECT pg_encoding_to_char(encoding), datcollate,
datctype FROM pg_database WHERE datname = 'template0'
pg_dumpall: executing SELECT datname, coalesce(rolname, (select rolname from
pg_authid where oid=(select datdba from pg_database where
datname='template0'))), pg_encoding_to_char(d.encoding), datcollate,
datctype, datfrozenxid, datistemplate, datacl, datconnlimit, (SELECT spcname
FROM pg_tablespace t WHERE t.oid = d.dattablespace) AS dattablespace FROM
pg_database d LEFT JOIN pg_authid u ON (datdba = u.oid) WHERE datallowconn
ORDER BY 1
pg_dumpall: executing SELECT datconfig[1] FROM pg_database WHERE datname =
'confluence';
pg_dumpall: executing SELECT datconfig[1] FROM pg_database WHERE datname =
'postgres';
pg_dumpall: executing SELECT datconfig[1] FROM pg_database WHERE datname =
'template1';
pg_dumpall: executing SELECT datname FROM pg_database WHERE datallowconn
ORDER BY 1
pg_dumpall: dumping database "confluence"...
pg_dumpall: running """C:/Program Files/pgAdmin III/1.10/pg_dump.exe"  -h
"localhost" -p "5432" -U "postgres" -v -f "E:\Backup\Backup19112010.sql" -Fa
"confluence"""
pg_dump: reading schemas
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading user-defined operator families
pg_dump: reading user-defined conversions
pg_dump: reading user-defined tables
pg_dump: reading table inheritance information
pg_dump: reading rewrite rules
pg_dump: reading type casts
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "keystore"
pg_dump: finding the columns and types of table "confversion"
pg_dump: finding the columns and types of table "os_user_group"
pg_dump: finding the columns and types of table "plugindata"
pg_dump: finding the columns and types of table "extrnlnks"
pg_dump: finding the columns and types of table "external_entities"
pg_dump: finding the columns and types of table "attachments"
pg_dump: finding the columns and types of table "os_user"
pg_dump: finding the columns and types of table "confancestors"
pg_dump: finding the columns and types of table "spaces"
pg_dump: finding the columns and types of table "label"
pg_dump: finding the columns and types of table "external_members"
pg_dump: finding the columns and types of table "local_members"
pg_dump: finding the columns and types of table "follow_connections"
pg_dump: finding the columns and types of table "spacegroups"
pg_dump: finding the columns and types of table "content"
pg_dump: finding the columns and types of table "links"
pg_dump: finding the columns and types of table "os_propertyentry"
pg_dump: finding the columns and types of table "bandana"
pg_dump: finding the columns and types of table "decorator"
pg_dump: finding the columns and types of table "trustedapprestriction"
pg_dump: finding the columns and types of table "bodycontent"
pg_dump: finding the columns and types of table "clustersafety"
pg_dump: finding the columns and types of table "spacepermissions"
pg_dump: finding the columns and types of table "content_label"
pg_dump: finding the columns and types of table "trackbacklinks"
pg_dump: finding the columns and types of table "contentlock"
pg_dump: finding the columns and types of table "imagedetails"
pg_dump: finding the columns and types of table "pagetemplates"
pg_dump: finding the columns and types of table "trustedapp"
pg_dump: finding the columns and types of table "notifications"
pg_dump: finding the columns and types of table "spacegrouppermissions"
pg_dump: finding the columns and types of table "content_perm"
pg_dump: finding the columns and types of table "groups"
pg_dump: finding the columns and types of table "attachmentdata"
pg_dump: finding the columns and types of table "os_group"
pg_dump: finding the columns and types of table "users"
pg_dump: finding the columns and types of table "content_perm_set"
pg_dump: finding the columns and types of table "indexqueueentries"
pg_dump: finding the columns and types of table "hibernate_unique_key"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "keystore"
pg_dump: reading indexes for table "confversion"
pg_dump: reading indexes for table "os_user_group"
pg_dump: reading indexes for table "plugindata"
pg_dump: reading indexes for table "extrnlnks"
pg_dump: reading indexes for table "external_entities"
pg_dump: reading indexes for table "attachments"
pg_dump: reading indexes for table "os_user"
pg_dump: reading indexes for table "confancestors"
pg_dump: reading indexes for table "spaces"
pg_dump: reading indexes for table "label"
pg_dump: reading indexes for table "external_members"
pg_dump: reading indexes for table "local_members"
pg_dump: reading indexes for table "follow_connections"
pg_dump: reading indexes for table "spacegroups"
pg_dump: reading indexes for table "content"
pg_dump: reading indexes for table "links"
pg_dump: reading indexes for table "os_propertyentry"
pg_dump: reading indexes for table "bandana"
pg_dump: reading indexes for table "decorator"
pg_dump: reading indexes for table "trustedapprestriction"
pg_dump: reading indexes for table "bodycontent"
pg_dump: reading indexes for table "clustersafety"
pg_dump: reading indexes for table "spacepermissions"
pg_dump: reading indexes for table "content_label"
pg_dump: reading indexes for table "trackbacklinks"
pg_dump: reading indexes for table "contentlock"
pg_dump: reading indexes for table "imagedetails"
pg_dump: reading indexes for table "pagetemplates"
pg_dump: reading indexes for table "trustedapp"
pg_dump: reading indexes for table "notifications"
pg_dump: reading indexes for table "spacegrouppermissions"
pg_dump: reading indexes for table "content_perm"
pg_dump: reading indexes for table "groups"
pg_dump: reading indexes for table "attachmentdata"
pg_dump: reading indexes for table "os_group"
pg_dump: reading indexes for table "users"
pg_dump: reading indexes for table "content_perm_set"
pg_dump: reading indexes for table "indexqueueentries"
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "keystore"
pg_dump: reading foreign key constraints for table "os_user_group"
pg_dump: reading foreign key constraints for table "extrnlnks"
pg_dump: reading foreign key constraints for table "external_entities"
pg_dump: reading foreign key constraints for table "attachments"
pg_dump: reading foreign key constraints for table "os_user"
pg_dump: reading foreign key constraints for table "confancestors"
pg_dump: reading foreign key constraints for table "spaces"
pg_dump: reading foreign key constraints for table "label"
pg_dump: reading foreign key constraints for table "external_members"
pg_dump: reading foreign key constraints for table "local_members"
pg_dump: reading foreign key constraints for table "spacegroups"
pg_dump: reading foreign key constraints for table "content"
pg_dump: reading foreign key constraints for table "links"
pg_dump: reading foreign key constraints for table "trustedapprestriction"
pg_dump: reading foreign key constraints for table "bodycontent"
pg_dump: reading foreign key constraints for table "spacepermissions"
pg_dump: reading foreign key constraints for table "content_label"
pg_dump: reading foreign key constraints for table "trackbacklinks"
pg_dump: reading foreign key constraints for table "contentlock"
pg_dump: reading foreign key constraints for table "imagedetails"
pg_dump: reading foreign key constraints for table "pagetemplates"
pg_dump: reading foreign key constraints for table "trustedapp"
pg_dump: reading foreign key constraints for table "notifications"
pg_dump: reading foreign key constraints for table "spacegrouppermissions"
pg_dump: reading foreign key constraints for table "content_perm"
pg_dump: reading foreign key constraints for table "groups"
pg_dump: reading foreign key constraints for table "attachmentdata"
pg_dump: reading foreign key constraints for table "os_group"
pg_dump: reading foreign key constraints for table "users"
pg_dump: reading foreign key constraints for table "content_perm_set"
pg_dump: reading triggers
pg_dump: reading triggers for table "keystore"
pg_dump: reading triggers for table "os_user_group"
pg_dump: reading triggers for table "extrnlnks"
pg_dump: reading triggers for table "external_entities"
pg_dump: reading triggers for table "attachments"
pg_dump: reading triggers for table "os_user"
pg_dump: reading triggers for table "confancestors"
pg_dump: reading triggers for table "spaces"
pg_dump: reading triggers for table "label"
pg_dump: reading triggers for table "external_members"
pg_dump: reading triggers for table "local_members"
pg_dump: reading triggers for table "spacegroups"
pg_dump: reading triggers for table "content"
pg_dump: reading triggers for table "links"
pg_dump: reading triggers for table "trustedapprestriction"
pg_dump: reading triggers for table "bodycontent"
pg_dump: reading triggers for table "spacepermissions"
pg_dump: reading triggers for table "content_label"
pg_dump: reading triggers for table "trackbacklinks"
pg_dump: reading triggers for table "contentlock"
pg_dump: reading triggers for table "imagedetails"
pg_dump: reading triggers for table "pagetemplates"
pg_dump: reading triggers for table "trustedapp"
pg_dump: reading triggers for table "notifications"
pg_dump: reading triggers for table "spacegrouppermissions"
pg_dump: reading triggers for table "content_perm"
pg_dump: reading triggers for table "groups"
pg_dump: reading triggers for table "attachmentdata"
pg_dump: reading triggers for table "os_group"
pg_dump: reading triggers for table "users"
pg_dump: reading triggers for table "content_perm_set"
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = off
pg_dump: saving database definition
pg_dump: creating SCHEMA public
pg_dump: creating COMMENT SCHEMA public
pg_dump: creating PROCEDURAL LANGUAGE plpgsql
pg_dump: creating TABLE attachmentdata
pg_dump: creating TABLE attachments
pg_dump: creating TABLE bandana
pg_dump: creating TABLE bodycontent
pg_dump: creating TABLE clustersafety
pg_dump: creating TABLE confancestors
pg_dump: creating TABLE confversion
pg_dump: creating TABLE content
pg_dump: creating TABLE content_label
pg_dump: creating TABLE content_perm
pg_dump: creating TABLE content_perm_set
pg_dump: creating TABLE contentlock
pg_dump: creating TABLE decorator
pg_dump: creating TABLE external_entities
pg_dump: creating TABLE external_members
pg_dump: creating TABLE extrnlnks
pg_dump: creating TABLE follow_connections
pg_dump: creating TABLE groups
pg_dump: creating TABLE hibernate_unique_key
pg_dump: creating TABLE imagedetails
pg_dump: creating TABLE indexqueueentries
pg_dump: creating TABLE keystore
pg_dump: creating TABLE label
pg_dump: creating TABLE links
pg_dump: creating TABLE local_members
pg_dump: creating TABLE notifications
pg_dump: creating TABLE os_group
pg_dump: creating TABLE os_propertyentry
pg_dump: creating TABLE os_user
pg_dump: creating TABLE os_user_group
pg_dump: creating TABLE pagetemplates
pg_dump: creating TABLE plugindata
pg_dump: creating TABLE spacegrouppermissions
pg_dump: creating TABLE spacegroups
pg_dump: creating TABLE spacepermissions
pg_dump: creating TABLE spaces
pg_dump: creating TABLE trackbacklinks
pg_dump: creating TABLE trustedapp
pg_dump: creating TABLE trustedapprestriction
pg_dump: creating TABLE users
pg_dump: restoring data for table "attachmentdata"
pg_dump: dumping contents of table attachmentdata
pg_dump: Dumping the contents of table "attachmentdata" failed:
PQgetCopyData() failed.
pg_dump: Error message from server: lost synchronization with server: got
message type "d", length 298692239
pg_dump: The command was: COPY public.attachmentdata (attachmentdataid,
attversion, data, attachmentid) TO stdout;
pg_dump: *** aborted because of error
pg_dumpall: pg_dump failed on database "confluence", exiting
Process returned exit code 1.

Thanks and regards

Sunil Vedd
Songas Limited