CAJ CAJ wrote:
Thanks for the response. This'd be wonderful if I can get my process
right. My assumptions (probably incorrect) are that pgdump has to be
excuted twice on a database with blobs. Once to get the data and once
to get the blob (using the -b flag).
Why do you assume that? T
> What is the fastest way to upgrade postgres for large databases that
> has binary objects?
Your procedure dumps and restore the databases twice. This seems less
than sound. My prediction is that you could get a 50% speed improvement
by fixing that ...
Thanks for the response. This'd be wo
CAJ CAJ wrote:
Hello,
I didn't get any response on the GENERAL list so i'm escalating this
We have several independent database servers with ~50GB+ databases
running postgres 8.0.x. We are planning to upgrade these databases to
postgres 8.2.x over the weekend
We plan to use the followi
Hello,
I didn't get any response on the GENERAL list so i'm escalating this
We have several independent database servers with ~50GB+ databases running
postgres 8.0.x. We are planning to upgrade these databases to postgres
8.2.xover the weekend
We plan to use the following steps to upgrade
