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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general