Thread: Server Configuration Tool not working
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
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
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.