Thread: Reverse compatibility

Reverse compatibility

From
"David Olbersen"
Date:
Hello all,

I 'found' a server I'd like to use for something database related. It's got an older version of postgres on it (7.0.2)
andI'd like to install an upgraded (7.3.2) client & associated libraries. 

I don't think this server is being used for anything, but if it is, will I end up making any database related items
failbecause of the newer client & libraries? 

--------------------------
David Olbersen
iGuard Engineer
St. Bernard Software
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152

Re: Reverse compatibility

From
Tom Lane
Date:
"David Olbersen" <DOlbersen@stbernard.com> writes:
> I 'found' a server I'd like to use for something database related. It's got an older version of postgres on it
(7.0.2)and I'd like to install an upgraded (7.3.2) client & associated libraries. 

> I don't think this server is being used for anything, but if it is, will I end up making any database related items
failbecause of the newer client & libraries? 

You might.  See the Release Notes for backwards-compatibility gotchas
introduced in 7.1, 7.2, or 7.3.  There aren't very many, but there are
some ...

            regards, tom lane

Re: Reverse compatibility

From
Vivek Khera
Date:
>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:

>> I don't think this server is being used for anything, but if it is,
>> will I end up making any database related items fail because of the
>> newer client & libraries?

TL> You might.  See the Release Notes for backwards-compatibility gotchas
TL> introduced in 7.1, 7.2, or 7.3.  There aren't very many, but there are
TL> some ...

I can tell you for sure that using the psql command line client from
7.3 will barf when connecting to a 7.2 server.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

Re: Reverse compatibility

From
"David Olbersen"
Date:
Vivek,

> I can tell you for sure that using the psql command line client from
> 7.3 will barf when connecting to a 7.2 server.

Is "barf" a technical term? :)

Perhaps I wasn't being clear enough. What I want to do is upgrade the client software on this machine so that I can use
itas a client for a 7.3 server. The only problem I worry about is any applications I don't know about which connect to
the7.2 server via the Pg Perl module, or something similar. 

--------------------------
David Olbersen
iGuard Engineer
St. Bernard Software
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152


> -----Original Message-----
> From: Vivek Khera [mailto:khera@kcilink.com]
> Sent: Tuesday, July 15, 2003 9:22 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Reverse compatibility
>
>
> >>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:
>
> >> I don't think this server is being used for anything, but if it is,
> >> will I end up making any database related items fail because of the
> >> newer client & libraries?
>
> TL> You might.  See the Release Notes for
> backwards-compatibility gotchas
> TL> introduced in 7.1, 7.2, or 7.3.  There aren't very many,
> but there are
> TL> some ...
>
> I can tell you for sure that using the psql command line client from
> 7.3 will barf when connecting to a 7.2 server.
>
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D.                Khera Communications, Inc.
> Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>

Re: Reverse compatibility

From
Vivek Khera
Date:
>>>>> "DO" == David Olbersen <DOlbersen@stbernard.com> writes:

DO> Vivek,
>> I can tell you for sure that using the psql command line client from
>> 7.3 will barf when connecting to a 7.2 server.

DO> Is "barf" a technical term? :)

Yes, but you only learn it in post-graduate comp-sci classes.

DO> Perhaps I wasn't being clear enough. What I want to do is upgrade
DO> the client software on this machine so that I can use it as a
DO> client for a 7.3 server. The only problem I worry about is any
DO> applications I don't know about which connect to the 7.2 server
DO> via the Pg Perl module, or something similar.

The C client library, ie, libpq, will speak with older and newer
versions of the server since the core protocol has not canged, AFAIK.

The command line programs and utilities are version specific.


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/