dev(9.1.9, for which pgadmin3 complains w/ that error) postgres=# \dx+ adminpack Objects in extension "adminpack" Object Description ------------------------------------------- function pg_file_length(text) function pg_file_read(text,bigint,bigint) function pg_file_rename(text,text) function pg_file_rename(text,text,text) function pg_file_unlink(text) function pg_file_write(text,text,boolean) function pg_logdir_ls() function pg_logfile_rotate() (8 rows)
dw(9.1.9) postgres=# \dx+ adminpack Did not find any extension named "adminpack".
prod(9.1.1) postgres=# \dx+ adminpack Did not find any extension named "adminpack".
Not sure what created these differences, but I used the same procedures to set them up. But these nodes went through different patches/upgrades, so maybe that's why.
Brian Wong wrote: >>>> -------------------------------------------------------------- >>>> An error has occurred: >>>> ERROR: could not access file "$libdir/adminpack": No such file or directory >>>> --------------------------------------------------------------
> I'm on Oracle Enterprise Linux. > > The server was already restarted after upgrading from 9.1.1 to 9.1.9. The server comes up just fine. > And on either versions on the box(9.1.1 and 9.1.9), adminpack.so isn't there. > > I looked on any postgresql box we have, adminpack.so just isn't there anywhere. > > And for some reason, this box is the only box for which pgadmin3 complains about it.
