Thread: Post-Upgrade Question: 9.0.1 -> 9.0.3

   After carefully following the instructions here:
      <http://www.postgresql.org/docs/9.0/static/install-upgrading.html>
I tested the upgrade from the command line. My question is why I still see a
reference to 9.0.1;

psql (9.0.1, server 9.0.3)
Type "help" for help.

   One database was created with 9.0.1 but another was created in the 7.x
era.

Rich

On Thursday, March 10, 2011 6:54:18 am Rich Shepard wrote:
>    After carefully following the instructions here:
>       <http://www.postgresql.org/docs/9.0/static/install-upgrading.html>
> I tested the upgrade from the command line. My question is why I still see
> a reference to 9.0.1;
>
> psql (9.0.1, server 9.0.3)
> Type "help" for help.
>
>    One database was created with 9.0.1 but another was created in the 7.x
> era.
>
> Rich


Your psql binary is from 9.0.1 your server from 9.0.3. Somewhere you have the
old psql in your path and it is being found first.
--
Adrian Klaver
adrian.klaver@gmail.com

On Thu, 10 Mar 2011, Adrian Klaver wrote:

> Your psql binary is from 9.0.1 your server from 9.0.3. Somewhere you have
> the old psql in your path and it is being found first.

   Huh! Wonder how that happened. I moved /usr/local/pgsql/ to
/usr/local/pgsql.9.0.1 and installed 9.0.3 into /usr/local.

   Well, regardless, I'll go looking when I return from walking the dogs.

Rich

On Thu, 10 Mar 2011, Adrian Klaver wrote:

> Your psql binary is from 9.0.1 your server from 9.0.3. Somewhere you have
> the old psql in your path and it is being found first.

Adrian,

   Found it. There was an executable /bin/psql in addition to
/usr/local/psql/bin/psql. I've no idea how the former got there during the
installation of 9.0.1.

   I removed /bin/psql and made a softlink from the 9.0.3 version to /bin.

Thanks,

Rich

On Thursday, March 10, 2011 8:11:37 am Rich Shepard wrote:
> On Thu, 10 Mar 2011, Adrian Klaver wrote:
> > Your psql binary is from 9.0.1 your server from 9.0.3. Somewhere you have
> > the old psql in your path and it is being found first.
>
> Adrian,
>
>    Found it. There was an executable /bin/psql in addition to
> /usr/local/psql/bin/psql. I've no idea how the former got there during the
> installation of 9.0.1.

My guess is you did a Postgres client only package install at some point:)

>
>    I removed /bin/psql and made a softlink from the 9.0.3 version to /bin.
>
> Thanks,
>
> Rich

--
Adrian Klaver
adrian.klaver@gmail.com

On Thu, 10 Mar 2011, Adrian Klaver wrote:

> My guess is you did a Postgres client only package install at some point:)

   Not consciously. When I upgraded from 8.4 to 9.0.1 last December
everything moved from /var/lib/pgsql to /usr/local/psql. The build/install
date on the executable /bin/psql matched that of the other binaries in
/usr/local/pgsql.9.0.1/bin/.

   9.0.3 was also installed into /usr/local.

Shrug,

Rich