Обсуждение: A forward-compatible pg_dump?

After *months* of delays, we are *finally* going to port all our databases
(and that's hundreds of small ones) to 6.4.2 from 6.2.1.

So, I took a test-case database and tried to load it from our backup dumps.
Ah... Close, but no cigar. Several syntax changes happened over the past
two years, including the dropping of archiving (obsoleting the "archive"
keyword in the dumps), and a change in the constraint syntax.

Also, old pg_dump doesn't dump privileges correctly, and frankly, it would
be a pain to enter each database and start granting from memory or a
handwritten list...

So, I recalled that there was somebody who wrote a forward-compatible
pg_dump. Something that works on 6.2.1 (or was it 6.1?) but outputs 6.4 or
6.3 schema syntax. Is that someone still around?

If so, can this thingy, wherever I may get it, be used to dump properly
from 6.2.1 to 6.4.2, and will it dump grants as well?

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

Herouth Maoz wrote:
  >After *months* of delays, we are *finally* going to port all our databases
  >(and that's hundreds of small ones) to 6.4.2 from 6.2.1.
  >...
  >So, I recalled that there was somebody who wrote a forward-compatible
  >pg_dump. Something that works on 6.2.1 (or was it 6.1?) but outputs 6.4 or
  >6.3 schema syntax. Is that someone still around?

My version was from 6.3.2 -> 6.4.  I have sent a copy to Herouth for
further hacking...

Would it be a good idea to have an archive of enhanced pg_dump programs
for earlier releases?

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Jesus saith unto him, I am the way, the truth, and the
      life; no man cometh unto the Father, but by me."
                                John 14:6