static pg_dump

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

Is there any way we could build a static version of the 7.4 pg_dump, to
make it easy to dump existing databases using the 7.4 dump? Otherwise,
it's quite difficult to arrange to have two different postgres
installations, etc...

Why?  There should be no problem installing both 7.3 and 7.4 libpq.so
--- if they don't have different version numbers, something's wrong.

regards, tom lane

Tom Lane <tgl@sss.pgh.pa.us> writes:

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

Is there any way we could build a static version of the 7.4 pg_dump, to
make it easy to dump existing databases using the 7.4 dump? Otherwise,
it's quite difficult to arrange to have two different postgres
installations, etc...

Why?  There should be no problem installing both 7.3 and 7.4 libpq.so
--- if they don't have different version numbers, something's wrong.

libpq? I thought only the minor version number changed. On linux that means
you can only usefully have one installed at once, the older one would never be
used. I think on other OSes the older one might be used sometimes.

In any case, can't 7.3 pg_dump use the 7.4 libpq?
If not then the major version should be bumped.

--
greg

Greg Stark wrote:

Tom Lane <tgl@sss.pgh.pa.us> writes:

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:

Is there any way we could build a static version of the 7.4 pg_dump, to
make it easy to dump existing databases using the 7.4 dump? Otherwise,
it's quite difficult to arrange to have two different postgres
installations, etc...

Why?  There should be no problem installing both 7.3 and 7.4 libpq.so
--- if they don't have different version numbers, something's wrong.

libpq? I thought only the minor version number changed. On linux that means
you can only usefully have one installed at once, the older one would never be
used. I think on other OSes the older one might be used sometimes.

In any case, can't 7.3 pg_dump use the 7.4 libpq?
If not then the major version should be bumped.

7.4 pg_dump should be able to use 7.3's libpq --- the API has not
changed, so we didn't bump the major number.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bruce Momjian <pgman@candle.pha.pa.us> writes:

7.4 pg_dump should be able to use 7.3's libpq --- the API has not
changed, so we didn't bump the major number.

No, the other way 'round. 7.3 pg_dump or psql would work with a 7.4
libpq.so, but I don't believe 7.4 pg_dump or psql would work with a
7.3 libpq.so.

regards, tom lane

In any case, can't 7.3 pg_dump use the 7.4 libpq?
If not then the major version should be bumped.

My point being that I would like to actually preserve my cluster
settings and stuff when dumping...

So it's pg_dump, not libpq, that's important to me.

Chris