Re: Anyone seen this message? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Anyone seen this message?
Date
Msg-id 20070712195354.GB22973@alvh.no-ip.org
Whole thread Raw
In response to Re: Anyone seen this message?  ("Ned Wolpert" <ned.wolpert@gmail.com>)
Responses Re: Anyone seen this message?  (Ned Wolpert <ned.wolpert@gmail.com>)
List pgsql-admin
Ned Wolpert escribió:

> In my current production environment, the PostgreSQL database server
> is the latest, 8.2.4.  The apps that communicate with it are planned
> to be running on stock CentOS5 servers, with the default 8.1.x (8.1.9)
> client libraries. So, not only is psql 8.1.9 (which I don't use on
> that server) but the libpq.so is from the 8.1.9 install.   Apache 2.2
> package uses the DBDriver module from the apr-util that was installed
> from CentOS, and we are planning to connect it to our PostgreSQL
> server.  Is that a 'bad thing' considering the libpq.so is a different
> major version?

No.  It is only a problem for psql because it uses some queries that
assume things about the system catalogs (for example psql 8.2 assumes
that pg_index.indisvalid exists, which it doesn't on 8.1).

Did you win the bet?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: "Ned Wolpert"
Date:
Subject: Re: Anyone seen this message?
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Re: How can I tell that the underlying OS is Windows?