Re: pg_upgrade issue

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. +