Re: Upgrade from 9.5.4 to 9.6.1 - Mailing list pgsql-general

From Rich Shepard
Subject Re: Upgrade from 9.5.4 to 9.6.1
Date
Msg-id alpine.LNX.2.11.1611160728350.13561@localhost
Whole thread Raw
In response to Re: Upgrade from 9.5.4 to 9.6.1  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Upgrade from 9.5.4 to 9.6.1
List pgsql-general
On Tue, 15 Nov 2016, Rich Shepard wrote:

> $ /usr/bin/pg_ctl --version
> pg_ctl (PostgreSQL) 9.6.1
>
> ls -al /usr/bin/pg_ctl
> lrwxrwxrwx 1 root root 32 Nov 15 14:16 /usr/bin/pg_ctl ->
> ../lib/postgresql/9.6/bin/pg_ctl*

   To increase my understanding I want to resolve an apparent discrepancy in
versions.

   After installing and initiating 9.6.1 that's reported as the current
running version, yet I've not yet migrated the cluster from 9.5.4 to 9.6.1.

   Last week, after a kernel upgrade, I rebooted the system and re-started
postgres pointing to the 9.5/data/ directory. When I enter the command
'psql -l' I see all the databases and assumed they running on 9.5.4. But
that's not the case, is it?

   If 9.6.1 is currently running after running initdb, and I can access my
databases, what does pg_upgrade do that's necessary?

A curious mind wants to learn,

Rich


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Change column type from int to bigint - quickest way
Next
From: Alban Hertroys
Date:
Subject: Re: Upgrade from 9.5.4 to 9.6.1