Re: Upgrade from 9.5.4 to 9.6.1

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrade from 9.5.4 to 9.6.1
Date: 2016-11-16 15:33:13
Message-ID: alpine.LNX.2.11.1611160728350.13561@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2016-11-16 15:52:00 Re: Upgrade from 9.5.4 to 9.6.1
Previous Message Merlin Moncure 2016-11-16 14:49:21 Re: Change column type from int to bigint - quickest way