Re: After upgrading from 9.1.1 to 9.1.9, pgadmin's server status window gives error

[Brian Wong <bwong@xxxxxxxxxxxxxx>]

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.albe@xxxxxxxxxx> 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