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
>
