Skip site navigation (1) Skip section navigation (2)

Re: Can't recover data from a .tar.gz file which was backed up using COPY BINARY command

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: Khangelani Gama <kgama(at)argility(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can't recover data from a .tar.gz file which was backed up using COPY BINARY command
Date: 2012-03-01 09:56:05
Message-ID: CAJghg4K3T+tg1R0dRyFgTF2cZDSMj4yuK_Gfn4LsviA-SgLQyg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Have you tried the above?

COPY BINARY dailybackup FROM <uncompressed file>

If so, what happened?

--
Matheus de Oliveira

Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho -
LCAD<http://www.lcad.icmc.usp.br/>
Instituto de Ciências Matemáticas e de Computação -
ICMC<http://www.icmc.usp.br/>
Universidade de São Paulo - USP <http://www.sc.usp.br/>




On Thu, Mar 1, 2012 at 4:51 AM, Khangelani Gama <kgama(at)argility(dot)com> 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 it out.
> Part of this script has something like, look at the COPY BINARY command
> just below:
>
>
>
> EXPORTFILE=${EXPORTFILE}.${AUD_UP_TO}_${MAX_AUDIT}
>
>    *$PSQL -c "COPY BINARY dailybackup TO '$EF_PATH/$EXPORTFILE';"*
>
>
>
>    if [ $? -eq 0 ]; then
>
>       cd $EF_PATH
>
>       tar cvzf ${EXPORTFILE}.tar.gz ${EXPORTFILE}
>
>       if [ $? -ne 0 ]; then
>
>          echo -e "Error while compressing tar file :  " >
> /tmp/backup.trickle.state
>
>          echo `date` >> /tmp/backup.trickle.state
>
>
>
> fi
>
>
>
>    echo "Backup to backup disk successful"
>
>
>
>    echo "Update trickle checkpoint"
>
>
>
>    ${ANT} run -Dclass=ucs.instore.ejb.system.SetTrickleCheckpoint
> -Darg1=${MAX_AUDIT}
>
>
>
>
>
>
>
> I tried to untar the file which went through fine, but now inside the file
> there is funny characters, see below:
>
>
>
> PGBCOPY
>
> ÿ^M
>
> ^(at)^D^C^B^A^@^(at)^@^(at)^@^(at)^@^(at)^R^@^D^(at)~UIS^@ÿÿ
> ^(at)^@^(at)1~1~1^D^@^É^(at)^@^D^(at)^@^(at)^@^(at)ÿÿ^K^@^(at)^@day_endÿÿ^K^(at)^@^(at)central^H^@wIôðå϶Aÿÿ¶^B^(at)^@<?xml
> version="1.0" encoding="UTF-8"?>^M
>
>
>
>
>
> I am aware of the following format, but can’t figure out how many
> characters should I specify and this backup system doesn’t use pg_dump
> command?
>
>
>
>
>
> COPY [ BINARY ] table_name [ WITH OIDS ]
>
>     FROM { 'filename' | STDIN }
>
>     [ [USING] DELIMITERS 'delimiter' ]
>
>     [ WITH NULL AS 'null string' ]
>
>
>
>
>
>
>
> Thanks in advanced
>
>
>
>
>
>
>
> CONFIDENTIALITY NOTICE
> The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. 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 immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.
>
>
>

In response to

Responses

pgsql-admin by date

Next:From: Khangelani GamaDate: 2012-03-01 10:16:54
Subject: Re: Can't recover data from a .tar.gz file which was backed up using COPY BINARY command
Previous:From: Simon RiggsDate: 2012-03-01 08:35:01
Subject: Re: Hot standby having high requested checkpoints?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group