"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> Should a 7.5 pg_restore be able to read a 7.4.3 dump? Assuming so, since
> doing upgrades could eb interesting if not, how far back can it go?
Theoretically it will work back to 7.0, or whenever it was that Philip
invented pg_restore. In practice
Marc G. Fournier wrote:
> On Tue, 15 Jun 2004, Bruce Momjian wrote:
>
> > Chris Bowlby wrote:
> >> Hi All,
> >>
> >> I've been attempting to recover some data from a data file that was
> >> dumped and compressed using pg_dump. I've noticed that the pg_restore
> >> application was supposed to hav
On Tue, 15 Jun 2004, Bruce Momjian wrote:
Chris Bowlby wrote:
Hi All,
I've been attempting to recover some data from a data file that was
dumped and compressed using pg_dump. I've noticed that the pg_restore
application was supposed to have some work put into place to help it
continue of it ran i
Chris Bowlby wrote:
> Hi All,
>
> I've been attempting to recover some data from a data file that was
> dumped and compressed using pg_dump. I've noticed that the pg_restore
> application was supposed to have some work put into place to help it
> continue of it ran into an error, but I've run
In that table I'm pretty sure there are no other records, but I'm hoping
there are some records for the tables stored after that particular table..
At 05:48 PM 6/15/2004, Tom Lane wrote:
Chris Bowlby <[EMAIL PROTECTED]> writes:
> pg_restore: restoring data for table "test_opens"
> pg_restore: res
Chris Bowlby <[EMAIL PROTECTED]> writes:
> pg_restore: restoring data for table "test_opens"
> pg_restore: restoring data for table "test_unsubs"
> pg_restore: [custom archiver] could not read data block -- expected 4096,
> got 3870
> pg_restore: *** aborted because of error
> It appears some o
Hi Vishal,
Unfortunately, this is not an option for me, I'm working with a file that
has 400505294 of 400513265 bytes that it can read successfully, however at
that spot in the file, there is a block that is 3870 bytes long as opposed
to the expected 4096 bytes. Running the command you gave me
Dear Chris ,
pg_restore: [custom archiver] could not read data block -- expected
4096, got 3870
pg_restore: *** aborted because of error
It appears some of the data itself is not readable, which is fine,
but I'd like it to skip past this table and move onto the next one.
Has anyone got any ide
Hi All,
I've been attempting to recover some data from a data file that was
dumped and compressed using pg_dump. I've noticed that the pg_restore
application was supposed to have some work put into place to help it
continue of it ran into an error, but I've run into an issue here it is not
con
