Обсуждение: pg_upgrade issue

Поиск
Список
Период
Сортировка

pg_upgrade issue

От
Marcos Cano
Дата:
so i'm trying to migrate/upgrade from 8.3.2 to 9.2.4 and following the instructions of the documentation i've found myself in a major issue which has overwhelmed my little knowledge.
these were the steps i followed:

1)downloand and install 9.2.4, with the contrib packages.
2)init the 9.2.4 cluster in /usr/local/pgsql9.2.4/data, i also have the 8.3.2 cluster in /usr/local/pgsql/data
3) stop both servers
4)change the 9.2.4 port to 5433
5) i run this command:

/usr/local/pgsql9.2.4/bin/./pg_upgrade -b /usr/local/pgsql/bin/ -B /usr/local/pgsql9.2.4/bin/ -c -d /usr/local/pgsql/data/ -D /usr/local/pgsql9.2.4/data/ -p 5432 -P 5433 -v


so after some 30 seconds the upgrade process seemed like "working"  but after it crashed
with this message:
Checking for presence of required libraries                 fatal

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
"/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/" -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1


so i went to check the log and found:


ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
STATEMENT:  LOAD '$libdir/liblwgeom'
command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/" -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1
LOG:  received fast shutdown request
LOG:  aborting any active transactions
waiting for server to shut down....FATAL:  terminating connection due to administrator command
LOG:  could not send data to client: Broken pipe
LOG:  shutting down
LOG:  database system is shut down
 done
server stopped


please help as i dont have any idea what's going wrong

Re: pg_upgrade issue

От
Bruce Momjian
Дата:
On Wed, Jun 19, 2013 at 11:37:30AM -0600, Marcos Cano wrote:
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> STATEMENT:  LOAD '$libdir/liblwgeom'
> command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/"
> -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1

OK, so your database references '$libdir/liblwgeom', but the file does
not exist in the 9.2.4 lib directory.  Odds are it is some Postgres
extension that you need to install in the new cluster.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


Re: pg_upgrade issue

От
Marcos Cano
Дата:
yes i guess is postgis... because we are using postgis in our DB but I wasn't aware 

On Wednesday, June 19, 2013, Bruce Momjian wrote:
On Wed, Jun 19, 2013 at 11:37:30AM -0600, Marcos Cano wrote:
> ERROR:  could not access file "$libdir/liblwgeom": No such file or directory
> STATEMENT:  LOAD '$libdir/liblwgeom'
> command: "/usr/local/pgsql9.2.4/bin/pg_ctl" -w -D "/usr/local/pgsql9.2.4/data/"
> -o "" -m fast stop >> "pg_upgrade_server.log" 2>&1

OK, so your database references '$libdir/liblwgeom', but the file does
not exist in the 9.2.4 lib directory.  Odds are it is some Postgres
extension that you need to install in the new cluster.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +