| Lists: | pgsql-general |
|---|
| From: | "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Problem With gunzip backup |
| Date: | 2007-08-01 07:27:43 |
| Message-ID: | 00d401c7d40d$77f3acb0$170211ac@LIONKING.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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.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...
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem With gunzip backup |
| Date: | 2007-08-01 08:35:20 |
| Message-ID: | 46B045C8.7000002@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com> |
| Subject: | Re: Problem With gunzip backup |
| Date: | 2007-08-01 08:47:10 |
| Message-ID: | 200708011047.10887.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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/