From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | stan <stanb(at)panix(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Cc: | crodmail(at)gmail(dot)com |
Subject: | Re: A question about upgrading on Debian/Ubuntu |
Date: | 2019-12-10 15:46:02 |
Message-ID: | 071bafb3-5f4e-d4d4-6ba3-57242d45c05a@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/10/19 3:21 AM, stan wrote:
> I upgraded successfully on our test machine from V11 to V12 the other day.
The below indicates that this is not the case.
> Now it is time to upgrade the production machine. One f the lessons
> learned in doing this is to do "make install" on all the extensions used
> in the existing DB before doing the pg_dropcluster.
If you are installing from packages then a good deal of the extensions
should be in postgresql-contrib and you do not have to do make install.
Do you have packages that come from outside contrib?:
https://www.postgresql.org/docs/12/contrib.html
>
> On the production machine I am confused by the state of the V12 server:
>
> If I do sudo apt-get install postgresql-12 I get a message about this
> package being marked to be "manually installed: pg_lsclusters reports on a
> version 11 instance:
Do have?:
/etc/postgresql/12/
>
> stan(at)smokey:~/src/pgemailaddr-master$ pg_lsclusters
> Ver Cluster Port Status Owner Data directory Log file
> 11 main 5432 online postgres /var/lib/postgresql/11/main
> /var/log/postgresql/postgresql-11-main.log
>
> And when I do a "make install" on one of the extensions, it installs in
> the V11 location.
Lets first see what you have for a 12 install before tackling that.
>
> What do I need to do to get the V12 server package correctly installed?
>
> Thanks, in advance.
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-12-10 15:59:08 | Re: PostgreSQL vs PostgresQL |
Previous Message | Vikas Sharma | 2019-12-10 15:40:48 | pgpool-II 3.7.5 with ssl |