Обсуждение: pgadminIII Configuration problem
Good Morning, 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? John ---- Who is General Failure, and why is he reading my hard disk?
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. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
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@lelarge.info] Gesendet: Samstag, 5. März 2011 20:27 An: Boblitz John Cc: pgadmin-support@postgresql.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. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com