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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
