Thread: Server Configuration Tool not working

Server Configuration Tool not working

From
"Jerrold \"Eric\" Thompson"
Date:
I am using pgadmin3, v1.10.5 on Debian Squeeze with PostgreSQL 8.4

I have installed the adminpack, by running the following:

su - postgres
psql template1 < /usr/share/postgresql/8.4/contrib/adminpack.sql

The output was:

CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION

However, the server configuration tool is still not available under the 
tools menu.
This is true even when I am logged in as superuser.

Shows up highlighted before connecting to a database, but then it is no
longer selectable.

Thanks,
   Jet










Re: Server Configuration Tool not working

From
Guillaume Lelarge
Date:
On Wed, 2012-01-04 at 23:57 -0800, Jerrold "Eric" Thompson wrote:
> I am using pgadmin3, v1.10.5 on Debian Squeeze with PostgreSQL 8.4
> 

1.10 is not maintained anymore. Please upgrade to a more recent release.

> I have installed the adminpack, by running the following:
> 
> su - postgres
> psql template1 < /usr/share/postgresql/8.4/contrib/adminpack.sql
> 

The adminpack extension must be included in the maintenance DB. By
default, it is the postgres database, not the template1.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
PostgreSQL Sessions #3: http://www.postgresql-sessions.org



Re: Server Configuration Tool not working

From
bluehandtalking
Date:
It is rather a catch 22 regarding the support issue. I am using a Debian
Squeeze Linux
distribution, and the only stable security recommended release at this time
is PostgreSQL 8.4,
and pgadmin3 v1.10.5. Also, Postgresql has, I believe, about 2 more years
before it is no
longer supported. Sure would be nice if support cycle of pgadmin3 was more
in sync with
a longer support cycle.

My issue was basically that I was not installing the admin pack correctly. I
followed some instructions
that were wrong, so was not  an issue with a bug.

I am posting the command that was 'wrong' for me (could be it works in other
situations), and the one that
got the server configuration tool working on my Debian Squeeze PostgreSQL
8.4 (with contrib/admin pack).

*Wrong:*

su - postgres
psql template1 < /usr/share/postgresql/8.4/contrib/adminpack.sql

*Right*

sudo -u postgres psql -d postgres <
/usr/share/postgresql/8.4/contrib/adminpack.sql

Cheers,     Jet


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Server-Configuration-Tool-not-working-tp5122045p5123526.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.