Thread: Patch to support transactions with BLOBs for current CVS
Hello, here it is as requested by Bruce. I tested it restoring my database with > 100000 BLOBS, and dumping it out. But unfortunatly I can not restore it back due to problems in pg_dump. -- Sincerely Yours, Denis Perchine ---------------------------------- E-Mail: dyp@perchine.com HomePage: http://www.perchine.com/dyp/ FidoNet: 2:5000/120.5 ----------------------------------
Attachment
At 18:19 21/10/00 +0700, Denis Perchine wrote:
>Hello,
>
>here it is as requested by Bruce.
>I tested it restoring my database with > 100000 BLOBS, and dumping it out.
>But unfortunatly I can not restore it back due to problems in pg_dump.
>
Please clarify - based on your last private email you stated that there was
not a problem with pg_dump, but a problem in the your BLOB patch:
>From: Denis Perchine <dyp@perchine.com>
>Date: Fri, 20 Oct 2000 12:15:18 +0700
>
>Sorry... I had a look inside server log... Looks like my bug...
>
Are you now saying there is a new problem with pg_dump?
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
> >here it is as requested by Bruce. > >I tested it restoring my database with > 100000 BLOBS, and dumping it out. > >But unfortunatly I can not restore it back due to problems in pg_dump. > > Please clarify - based on your last private email you stated that there was > > not a problem with pg_dump, but a problem in the your BLOB patch: Yeps. I have fixed all the crap. And it restores perfect from my archive which I made some time ago with your pg_dump for 7.0.2. It was _10 if I am not mistaken. Also it dumps out fine, but restore back from new archive stops right away. And when I tried to do dump/restore on the empty database I was failed. > >From: Denis Perchine <dyp@perchine.com> > >Date: Fri, 20 Oct 2000 12:15:18 +0700 > > > >Sorry... I had a look inside server log... Looks like my bug... > > Are you now saying there is a new problem with pg_dump? > > > ---------------------------------------------------------------- > Philip Warner | __---_____ > Albatross Consulting Pty. Ltd. |----/ - \ > (A.B.N. 75 008 659 498) | /(@) ______---_ > Tel: (+61) 0500 83 82 81 | _________ \ > Fax: (+61) 0500 83 82 82 | ___________ | > Http://www.rhyme.com.au | / \| > > | --________-- > > PGP key available upon request, | / > and from pgp5.ai.mit.edu:11371 |/ -- Sincerely Yours, Denis Perchine ---------------------------------- E-Mail: dyp@perchine.com HomePage: http://www.perchine.com/dyp/ FidoNet: 2:5000/120.5 ----------------------------------
At 18:36 21/10/00 +0700, Denis Perchine wrote:
>> >here it is as requested by Bruce.
>> >I tested it restoring my database with > 100000 BLOBS, and dumping it out.
>> >But unfortunatly I can not restore it back due to problems in pg_dump.
>>
>> Please clarify - based on your last private email you stated that there was
>>
>> not a problem with pg_dump, but a problem in the your BLOB patch:
>
>Yeps. I have fixed all the crap. And it restores perfect from my archive
>which I made some time ago with your pg_dump for 7.0.2. It was _10 if I am
>not mistaken.
>
>Also it dumps out fine, but restore back from new archive stops right away.
>And when I tried to do dump/restore on the empty database I was failed.
>
This is the same recent bug as from the hacker list?
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
> >Yeps. I have fixed all the crap. And it restores perfect from my archive > >which I made some time ago with your pg_dump for 7.0.2. It was _10 if I am > >not mistaken. > > > >Also it dumps out fine, but restore back from new archive stops right > > away. And when I tried to do dump/restore on the empty database I was > > failed. > > This is the same recent bug as from the hacker list? Yeps. I just made a comment that I was unable to make a complete circle in my tests. :-))) -- Sincerely Yours, Denis Perchine ---------------------------------- E-Mail: dyp@perchine.com HomePage: http://www.perchine.com/dyp/ FidoNet: 2:5000/120.5 ----------------------------------
Applied. Thanks. I know it is a pain to generate a new patch against the release. [ Charset koi8r unsupported, skipping... ] [ Attachment, skipping... ] -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026