Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem With gunzip backup

Problem With gunzip backup

From
"Ashish Karalkar"
Date:
Hello All,
I am having following PostgreSQL & Linux version
 
 PostgreSQL 8.2.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3 20041212 (Red Hat 3.4.3-9.EL4)
 
I am trying to create the backupfile using gunzip utility
 
pg_dump qsweb | gzip > /usr/local/backup/backup.gz
But when I run this command i get error
 stdin: not in gzip format
tried with 
pg_dump qsweb | gzip > /usr/local/backup/backup.tar.gz
but same problem again
Can any body please suggest what is going wrong
 
Thanks In advance
With Regards
Ashish...
 
 
 
 

Re: Problem With gunzip backup

From
Richard Huxton
Date:
Ashish Karalkar wrote:
>
> I am trying to create the backupfile using gunzip utility
>
> pg_dump qsweb | gzip > /usr/local/backup/backup.gzBut when I run this
> command i get error stdin: not in gzip formattried with pg_dump qsweb
> | gzip > /usr/local/backup/backup.tar.gzbut same problem againCan any
> body please suggest what is going wrongThanks In advanceWith

Not sure what you're doing wrong, but there's no need to do this. Use
   pg_dump -Fc ...
This format is already compressed.

--
   Richard Huxton
   Archonet Ltd

Re: Problem With gunzip backup

From
Peter Eisentraut
Date:
Am Mittwoch, 1. August 2007 09:27 schrieb Ashish Karalkar:
> pg_dump qsweb | gzip > /usr/local/backup/backup.gzBut when I run this
> command i get error stdin: not in gzip formattried with pg_dump qsweb |
> gzip > /usr/local/backup/backup.tar.gzbut same problem againCan any body
> please suggest what is going wrongThanks In advanceWith RegardsAshish...

Check if you have the GZIP environment variable set.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/