Any one has any clue how to fix this? ~ Brian
On Mon, Aug 12, 2013 at 1:47 PM, Brian Wong <bw...@imageworks.com> wrote: > Actually it is kinda complicated: > > *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 > > > On Fri, Aug 9, 2013 at 12:27 AM, Albe Laurenz <laurenz.a...@wien.gv.at>wrote: > >> 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. >> >> Are the objects there on all machines? >> >> What do you get for "\dx+ adminpack" in psql? >> >> Yours, >> Laurenz Albe >> > >
