From: | Brian Wong <bwong(at)imageworks(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: After upgrading from 9.1.1 to 9.1.9, pgadmin's server status window gives error |
Date: | 2013-08-12 20:47:13 |
Message-ID: | CA+dZhzJcrvP-duFX_Huai3eWnTMfUkCB2VnZ3+4z84rWqFte5w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-08-12 20:48:08 | Re: Opinions on SSDs |
Previous Message | David F. Skoll | 2013-08-12 20:41:48 | Re: Opinions on SSDs |