Re: Upgrade from 9.5.4 to 9.6.1

On 11/15/2016 05:06 PM, Rich Shepard wrote:
> On Tue, 15 Nov 2016, Adrian Klaver wrote:
>
>> Assuming the bindirs are in your $PATH:
>>
>> aklaver(at)panda:~> whereis -f pg_ctl
>
> Adrian,
>
> In my case:
>
> $ whereis -f pg_ctl
> pg_ctl: /bin/pg_ctl /usr/bin/pg_ctl /usr/X11R6/bin/pg_ctl
> /usr/bin/X11/pg_ctl /usr/X11/bin/pg_ctl /usr/man/man1/pg_ctl.1
> /usr/man/man1/pg_ctl.1.gz /usr/share/man/man1/pg_ctl.1
> /usr/share/man/man1/pg_ctl.1.gz /usr/X11/man/man1/pg_ctl.1
> /usr/X11/man/man1/pg_ctl.1.gz

So what do you get with

/usr/bin/pg_ctl --version

and given John's suggestion:

ls -al /usr/bin/pg_ctl

>
>> Even if only one is the $PATH:
>
>> you can usually figure out where the other is.
>
> I suppose if I knew which version is in each of those directories it
> would
> make life easier.
>
> Currently, only 9.5.4 is running; 9.6.1 is installed and initiated but
> not
> running. When I invoke 'psql -l' I see the clusters installed in 9.5.4.

So how are you going to start the 9.6 instance?

>
> Will use pg_dumpall and pg_restore ... tomorrow morning.
>
> Thanks very much,
>
> Rich
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com