On 12/10/19 8:14 AM, stan wrote:
On Tue, Dec 10, 2019 at 07:46:02AM -0800, Adrian Klaver wrote:
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.
It is installed:
dpkg -l
ii postgresql-contrib
Do you have packages that come from outside contrib?:
https://www.postgresql.org/docs/12/contrib.html
Yes, pgemailaddr is one.
https://github.com/petere/pgemailaddr
Installation
To build and install this module:
make
make install
**--> or selecting a specific PostgreSQL installation:
make PG_CONFIG=/some/where/bin/pg_config
make PG_CONFIG=/some/where/bin/pg_config install
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
