Re: pg_upgrade + Extensions
Tom,
I just tested and yes that worked. Once we have the new library for the hostname, pg_upgrade is not complaining about the hostname extension.
Another thing we found is this. We needed to drop json_build extension before the upgrade. However the upgrade fails with the following error and the way to resolve it is to install json_build94 library. Any ideas why this might be?
/usr/pgsql-9.4/bin/pg_upgrade --check --link
...
....
Your installation references loadable libraries that are missing from the
new installation. You can add these libraries to the new installation,
or remove the functions using them from the old installation. A list of
problem libraries is in the file:
loadable_libraries.txt
Failure, exiting
[postgres@pdxdvrptsrd04 ~]$ cat loadable_libraries.txt
Could not load library "json_build"
ERROR: could not access file "json_build": No such file or directory
Thanks
Smitha
On Fri, Jul 10, 2015 at 10:59 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"David E. Wheeler" <david@justatheory.com> writes:
> My co-workers tell me that pg_upgrade told them to drop the colnames and
> hostname extensions before upgrading from 9.3 to 9.4.
Really? I see nothing in the source code that would print any such
advice.
There *is* a check on whether .so libraries used by the source
installation exist in the destination one. But the preferred way to
deal with that type of complaint is to install the needed libraries
(in the destination's lib/ folder). You shouldn't have to drop anything
as long as you have a copy of the extension that works for the new PG
version.
regards, tom lane
Smitha Pamujula
Database Administrator // The Watch Woman
Direct: 503.943.6764
Mobile: 503.290.6214 // Twitter: iovation
www.iovation.com
www.iovation.com
В списке pgsql-hackers по дате отправления: