Re: pg_restore -m failing

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: ohp(at)pyrenet(dot)fr
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_restore -m failing
Date: 2009-03-03 16:02:35
Message-ID: 49AD549B.4000604@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ohp(at)pyrenet(dot)fr wrote:
> hi all,
>
> After Andrew corrected the bug I found on pg_restore (-C -m
> misbehaving one with the other), I played again yesterday.
>
> before the end of restore, I get this :
>
> pg_restore: launching item 4202 INDEX idx_typeper_actif
> pg_restore: [custom archiver] could not close archive file: Argument
> incorrect
> pg_restore: *** aborted because of error
> pg_restore: finished item 4202 INDEX idx_typeper_actif
> pg_restore: [archiver] worker process failed: exit code 1
> pg_restore: *** aborted because of error
>
> Any idea? this is on unixware
>

That seems very strange. Is it repeatable. I wonder what theincorrect
argument was? Maybe the memory got clobbered somewhere.

Actually, while thinking about this it occurred to me that we are
probably wasting a few cycles reopening the archive where we don't need
to - it should only be necessary where we are restoring a data member,
ISTM. I'll look at that further.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2009-03-03 16:16:05 Re: Immediate shutdown and system(3)
Previous Message ohp 2009-03-03 15:03:29 pg_restore -m failing