Skip site navigation (1) Skip section navigation (2)

Re: 8.2.4 pg_restore on WinXP and pipes

From: David Wall <d(dot)wall(at)computer(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.2.4 pg_restore on WinXP and pipes
Date: 2007-08-22 01:00:40
Message-ID: 46CB8AB8.4040206@computer.org (view raw or flat)
Thread:
Lists: pgsql-admin
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 wrote:
>>>> On Tue, Aug 21, 2007 at  7:23 PM, in message <46CB81EF(dot)7080403(at)computer(dot)org>,
>>>>         
> David Wall <d(dot)wall(at)computer(dot)org> 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 curiosity, does it do the same thing for?:
>  
> gunzip < backup81.gz | pg_restore -v -O -d mydb
>  
> -Kevin
>  
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>   

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2007-08-22 01:02:38
Subject: Re: tar, but not gnu tar
Previous:From: Kevin GrittnerDate: 2007-08-22 00:50:11
Subject: Re: 8.2.4 pg_restore on WinXP and pipes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group