Hi= Matheus

=A0

I get the following error when tryin= g your command:

=A0

ERROR:=A0 COPY BINARY: file signature = not recognized

=A0

From: Matheus de Oliveira= [mailto:matioli.matheus@gmail= .com]
Sent: Thursday, March 01, 2012 11:56 AM
To: Khangelani Gam= a
Cc: pgsql-admin@p= ostgresql.org
Subject: Re: [ADMIN] Can't recover data fro= m a .tar.gz file which was backed up using COPY BINARY command

=A0

Have you tried the above?

COPY BINARY dailybackup FROM <uncompressed file>

If so, what happened?

--
Matheus de Oliveira

Bacharela= do em Ci=EAncias de Computa=E7=E3o
Laborat=F3rio de Computa=E7=E3o de Alto Desempenho - = LCAD
Instituto de Ci=EAnci= as Matem=E1ticas e de Computa=E7=E3o - ICMC
Universidade de S=E3o Paulo - USP

On Thu, Mar 1, 2012 at 4:51 AM, Khangelani Gama <= kgama@argility.com<= /a>> wrote:

Someone in our company wrote a script that backs up data from a= certain table, that person left the company and no one is able to figure i= t out. Part of this script has something like, look at the COPY BINARY comm= and just below:

=A0

EXPORTFILE=3D${EXPORTFILE}.${AUD_UP_TO}_${MAX_AU= DIT}

=A0=A0 $PSQL -c "COPY BINARY d= ailybackup TO '$EF_PATH/$EXPORTFILE';"

=A0

=A0=A0 if = [ $? -eq 0 ]; then

=A0=A0=A0=A0=A0 cd $EF_P= ATH

=A0=A0=A0=A0=A0 tar cvzf ${EXPORTFILE}.= tar.gz ${EXPORTFILE}

=A0=A0=A0=A0=A0 if [ $? -ne 0 ]; then

=A0= =A0=A0=A0=A0=A0=A0=A0 echo -e "Error while compressing tar file :=A0 &= quot; > /tmp/backup.trickle.state

=A0=A0= =A0=A0=A0=A0=A0=A0 echo `date` >> /tmp/backup.trickle.state

=A0

=A0=A0 echo "Backup to backup disk successful"

<= p class=3D"MsoNormal" style> =A0

=A0=A0 echo "Update trickle checkp= oint"

=A0=A0 =A0

=A0=A0 ${ANT} run -Dclass=3Ducs.instore.ejb.system.SetTrickleChe= ckpoint -Darg1=3D${MAX_AUDIT}

=A0

I tried to untar the file which went through = fine, but now inside the file there is funny characters, see below:<= /p>

=A0

PGBCOPY

=FF^M

^@^D^C^B^A^@^@^@^@^@^@^@^@^R^@^D^@~UIS^@=FF=FF=A0=A0=A0= =A0=A0 ^@^@^@1~1~1^D^@^=C9^@^@^D^@^@^@^@^@=FF=FF^K^@^@^@day_end=FF=FF^K^@^@= ^@central^H^@wI=F4=F0=E5=CF=B6A=FF=FF=B6^B^@^@<?xml version=3D"1.0&= quot; encoding=3D"UTF-8"?>^M

=A0

I am aware of the following f= ormat, but can=92t figure out how many characters should I specify and this= backup system doesn=92t use pg_dump command?

=A0

COPY [ BINARY ] table_name [ WITH OIDS ]

=A0=A0=A0 FROM { 'filename' | STDIN }=

=A0=A0=A0 [ [USING] DELIMITERS 'delimiter= 9; ]

=A0=A0=A0 [ WITH NULL AS 'null string' ]

=A0

Thanks in advanced

=A0

CONFIDENTIALITY NOTICE

The contents of and attachme=
nts to this e-mail are intended for the addressee only, and may contain the=
 confidential information of Argility (Proprietary) Limited and/or its subs=
idiaries. Any review, use or dissemination thereof by anyone other than the=
 intended addressee is prohibited.

If you are not the intended addressee please notify the writer immedia=
tely and destroy the e-mail. Argility (Proprietary) Limited and its subsidi=
aries distance themselves from and accept no liability for unauthorised use=
 of their e-mail facilities or e-mails sent other than strictly for busines=
s purposes.

=A0

=A0




CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addre=
ssee only, and may contain the confidential information of Argility (Prop=
rietary) Limited and/or its subsidiaries. Any review, use or disseminatio=
n thereof by anyone other than the intended addressee is prohibited.
If you are not the intended addressee please notify the writer immediatel=
y and destroy the e-mail. Argility (Proprietary) Limited and its subsidia=
ries distance themselves from and accept no liability for unauthorised us=
e of their e-mail facilities or e-mails sent other than strictly for busi=
ness purposes.
=0D
--14dae934037dcac11704ba2bc0e5--