[ADMIN] 8.2.4 pg_restore on WinXP and pipes

I'm using cygwin on WinXP and upgrading from 8.1 to 8.2.4. Under 8.1, I ran a full backup and stored that as GZIP file. Under 8.2, I tried to restore using the command: gunzip -c backup81.gz | pg_restore -v -O -d mydb This returned an error: pg_restore: [archiver] did not find magic string i

Re: [ADMIN] 8.2.4 pg_restore on WinXP and pipes

>>> On Tue, Aug 21, 2007 at 7:23 PM, in message <[EMAIL PROTECTED]>, David Wall <[EMAIL PROTECTED]> wrote: > I'm using cygwin on WinXP > > gunzip -c backup81.gz | pg_restore -v -O -d mydb > > This returned an error: pg_restore: [archiver] did not find magic > string in file header Out of cu

Re: [ADMIN] 8.2.4 pg_restore on WinXP and pipes

Yes it does the same thing: $ gunzip < mydb.dump.20070819.gz | pg_restore -v -O -d mydb pg_restore: [archiver] did not find magic string in file header Most odd since it seems to work just fine if gunzip first and then use: pg_restore -v -O -d mydb < mydb.dump.20070819 David Kevin Grittner