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



Fri, 31 Oct 2003 14:42:08 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
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

Fri, 31 Oct 2003 08:56:33 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: static pg_dump 
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


31 Oct 2003 11:34:53 -0500
Greg Stark <gsstark@mit.edu>
Re: static pg_dump
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

Fri, 31 Oct 2003 15:40:18 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: static pg_dump
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

Fri, 31 Oct 2003 16:35:13 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: static pg_dump 
> 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


Sat, 01 Nov 2003 18:44:29 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: static pg_dump