Обсуждение: static pg_dump
Hey guys, 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... Chris
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, Pennsylvania19073
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