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

Re: pg_restore problem

From: Harco de Hilster <Harco(dot)de(dot)Hilster(at)ATConsultancy(dot)nl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Andreasen <michael(at)dunlops(dot)com>,pgsql-bugs(at)postgresql(dot)org
Subject: Re: pg_restore problem
Date: 2006-05-31 10:38:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
I had similar problems with the tar format. 3 smaller databases worked, 
the biggest did not. Switching to -Fc fixed it for me.

Sorry for not reporting this.


Tom Lane wrote:
> Michael Andreasen <michael(at)dunlops(dot)com> writes:
>> pg_dump -Ft $db | bzip2 > $db.dump.tbz
>> ...
>> pg_restore: [tar archiver] could not find header for file 3765.dat in 
>> tar archive
> Does it work better if you use -Fc format?  There was a similar report
> recently, which makes me think the tar-format code has got some kind
> of problem, but without a test case it's hard to look into it.
> 			regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?

In response to

pgsql-bugs by date

Next:From: raja chidambaramDate: 2006-05-31 10:46:08
Subject: BUG #2460: bug on postgres crash recovery
Previous:From: Henrik ZagerholmDate: 2006-05-31 06:43:59
Subject: Re: reindexdb command utlility

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