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

Any one has any clue how to fix this? ~ Brian

On Mon, Aug 12, 2013 at 1:47 PM, Brian Wong <bwong(at)imageworks(dot)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(dot)albe(at)wien(dot)gv(dot)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
>>
>
>