From: Marcos Cano <mcano@stsa.info>
To: pgsql-admin@postgresql.org
Subject: PG_UPGRADE major issue
Date: Wed, 19 Jun 2013 10:09:37 -0700 (PDT)
Message-ID: <1371661777006-5759906.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PG-UPGRADE-major-issue-tp5759906.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mcano@stsa.info
Subject: Re: PG_UPGRADE major issue
In-Reply-To: <1371661777006-5759906.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox