Reverse compatibility

Started by David Olbersenover 22 years ago5 messagesgeneral
Jump to latest
#1David Olbersen
DOlbersen@stbernard.com

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) 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 fail because 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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: David Olbersen (#1)
Re: Reverse compatibility

"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 fail because 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

#3Vivek Khera
khera@kcilink.com
In reply to: David Olbersen (#1)
Re: 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/

#4David Olbersen
DOlbersen@stbernard.com
In reply to: Vivek Khera (#3)
Re: Reverse compatibility

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 it as a client for a 7.3 server. The only problem I worry about is any applications I don't know about which connect to the 7.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

Show quoted text

-----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

#5Vivek Khera
khera@kcilink.com
In reply to: David Olbersen (#4)
Re: Reverse compatibility

"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/