Re: SOLVED pgadminIII Configuration problem

Merci!

That fixed the problem!

Cheers,

John

----

Who is General Failure, and why is he reading my hard disk?

-----Ursprüngliche Nachricht-----
Von: Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Gesendet: Samstag, 5. März 2011 20:27
An: Boblitz John
Cc: pgadmin-support(at)postgresql(dot)org
Betreff: Re: [pgadmin-support] pgadminIII Configuration problem

Hi,

Le 01/03/2011 11:04, Boblitz John a écrit :
> [...]
> I have the following setup:
>
> Debian <<squeeze>> Server with the following PostgreSQL modules:
>
> i odbc-postgresql 1:08.03.02
> 1:08.03.02
> i pgadmin3 1.10.5-1
> 1.10.5-1
> i A pgadmin3-data 1.10.5-1
> 1.10.5-1
> i A pgagent 3.0.1-1
> 3.0.1-1
> i postgresql 8.4.7-0squ
> 8.4.7-0squ
> i A postgresql-8.4 8.4.7-0squ
> 8.4.7-0squ
> i postgresql-8.4-debversion 1.0.3-1+b1
> 1.0.3-1+b1
> i postgresql-client 8.4.7-0squ
> 8.4.7-0squ
> i A postgresql-client-8.4 8.4.7-0squ
> 8.4.7-0squ
> i A postgresql-client-common 113
> 113
> i A postgresql-common 113
> 113
> i postgresql-contrib 8.4.7-0squ
> 8.4.7-0squ
> i A postgresql-contrib-8.4 8.4.7-0squ
> 8.4.7-0squ
>
> Simple Database is set up and I can query from the server.
>
> To Administer from my local PC (WinXP), I installed pgadminIII
> (v1.12.2) and configured it to connect to the server which works, to a
> point.
>
> I can see the database and can query the test file. However, I keep
> getting the message that an adminpack needs to be set up. Supposedly,
> this is already in the postgresql-contrib* - but I am unable to find
> the correct Directory /usr/local/pgsql/share/contrib/.
>
> Any ideas what I have done wrong?
>

On Debian, you need to execute
/usr/share/postgresql/8.4/contrib/adminpack.sql in your postgres database to install the adminpack.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com