-
Title
Database Backup error: "Table present, but failed to backup Table : '\xXXXX..post_category" -
Description
Cannot backup tables of one of the schemas. Tables from a different schema in the same database are OK.
Logs show:
Job Message 2013/12/18 19:06:04 624 Data Plugin Launching backup command : '/var/PostgreSQL/9.2/bin/pg_dump --format=plain --inserts --table="post_category" --schema="" "\xXXXX" '
Error 2013/12/18 19:06:04 624 Data Plugin Table present, but failed to backup Table : '\xXXXXX..post_category'.Trace shows:
2 PGBACKUP:06950 43 0 102753.812470 No data returned from fread()
2 PGBACKUP:06950 45 0 102753.812511 feof() is true; reached end of data
2 PGBACKUP:06950 46 0 102753.812561 pclose return value: 256
0 PGBACKUP:06950 47 0 102753.812573 pclose: exited with status [1]
0 POSTGRE :06950 6 0 102753.812584 Staus code raised from : 0 to :2
0 PGBACKUP:06950 76 0 102753.814052 Table present, but failed to bacckup Table : '\xXXXXXX..post_nature' .
0 PGBACKUP:06950 34 0 102753.814064 Job failed so abort the Stream -
Cause
EnterpriseDB is not supported. -
Resolution
WORKAROUND 1
Upgrade to the latest Plugin for PostgreSQL 3.2 or later if using EnterpirseDB
WORKAROUND 2
If already using the supported plugin and the backup failed while backing certain table in PostgreSQL, when that is excluded the backup completes.
Binary log :-Job Message 2016/02/25 14:38:42 205 Data Plugin PostgressDB01Launching backup command : '/usr/pgsql-9.3/bin//pg_dump --format=plain --inserts --table='"pg_temp_2"'.'"foldertree1"' "payu" 'Error 2016/02/25 14:38:42 205 Data Plugin PostgressDB01 Table present, but failed to backup Table : 'payu.pg_temp_2.foldertree1'.Job Message 2016/02/25 14:38:43 205 Media PostgressDB01 (NetVault_backup06\VTL06) Drive 'DRIVE 2:PostgressDB01' has completed its transferError 2016/02/25 14:38:43 205 Jobs PostgressDB01 Fatal error: Backup failed
When we backed up via commandline also we got the same error.
/usr/pgsql-9.3/bin//pg_dump --format=plain --inserts --table='"pg_temp_2"'.'"foldertree1"' "payu" '
Table present, failed to backup Table : 'payu.pg_temp_2.foldertree1'.
End user dba had created different schema for test and had set the "foldertree1" table with different permission and the backup works.
Also check the file pg_hba.conf on the clinet for TRUST authentication for the HOST connection & LOCAL connection while using PASSWORD authentication.
eg :- pg_hba.confhost all postgres 127.0.0.1/32 trusthost all postgres <ip of backup servernvbu> /32 trusthost all postgres <ip of clinet server > /32 trust