Re: Problem With gunzip backup

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
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-08-01 08:36:32 Re: Possible to Attach/Detach Tablespaces?
Previous Message Dimitri Fontaine 2007-08-01 08:31:16 Re: {Spam} FOREIGN KEY migration of syntax, help needed