Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have a Windows server that runs postgresql 9.2. I want to hit it using pgAdmin III from my Ubuntu 12.10 workstation box.

I installed pgAdmin III from synaptic and also tried direct download from postgreSQL site using software installer. Regardless, I can get only get pgAdmin III for postgresql 9.1. When I run pgAdmin III and point to my server I get an error message telling me that the database is 9.2 and my pgAdmin III is for 9.1, isn't compatible with 9.2.

I can access the server itself fine OK from the Ubuntu box - I have Python programs that hit the database with no problems - but I need pgAdmin III for 9.2 running under Ubuntu 12.10.

Is it available? Where do I get it?

share|improve this question
add comment

2 Answers

It is in the repositories.

sudo apt-get install pgadmin3

or search the software center.

software-center

If that is the wrong version, you could use the PPA:

If that does not work you can use the source and compile it yourself from source.

share|improve this answer
    
Thank you - I will try this. –  comeAndGo Nov 23 '12 at 8:05
add comment

Version 16 of pgadmin3 ( http://www.pgadmin.org/visualtour16.php ) is required for Postgres 9.2 and it is not in the repo or that PPA for Ubunutu 12.10.

It looks like you have to build it or upgrade.

I've built it for 12.10: https://copy.com/anB4E19CxdLW - perhaps that binary will work for you if you are on 12.10.

If not and you need to build it yourself, make sure you install

sudo apt-get install postgresql-server-dev-9.2
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.