8.2.4 pg_restore on WinXP and pipes
От | David Wall |
---|---|
Тема | 8.2.4 pg_restore on WinXP and pipes |
Дата | |
Msg-id | 46CB81EF.7080403@computer.org обсуждение исходный текст |
Ответы |
Re: 8.2.4 pg_restore on WinXP and pipes
|
Список | pgsql-admin |
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 in file header The above commands work fine under Linux/Unix. What's interesting is that if I just gunzip the file and run it with non-pipe input redirection, the same thing works fine (so the data is good): gunzip backup81.gz pg_restore -v -O -d mydb < backup81 gzip backup81 It as if the pipe for stdin isn't working, but the other does. Any ideas? I'd prefer to not have to gunzip and then gzip and use the pipe as this is the common script we use on Linux and aside from this problem, works well when we run the same scripts under cygwin with WinXP. Thanks, David
В списке pgsql-admin по дате отправления: