Pgadmin on Ubuntu 10.10

royster-doyster · 01-16-2011, 03:59 PM

I am in the process of looking to migrate my PC from Windows 7 to Ubuntu 10.10 as I like it and i find it a little quicker than Windows. One of the major failings I find at the moment is software app support. I am setting up some PostgreSQL 9.0 servers (to do streaming replication) and using pgadmin to do the management.

Under Windows this app works great, but under Ubuntu it seems the standard package only supports up to 8.4, and looks like support has been dropped for pgadmin on Ubuntu.

What I can't understand is the open source movement isn't supporting itself - or is it that because 10.10 is not on LTS, they are waiting for the next version to update the package - anyone know?

If its not supported then back to Windows I go, because I know the latest version works fine.

Anybody any ideas?

Thanks,

R2TD.

stress_junkie · 01-16-2011, 05:21 PM

I got this link from the PostgreSQL download web page.
http://www.enterprisedb.com/products...ing/pgdownload
They say that the 9.x version is supported on Ubuntu 8 and above.

royster-doyster · 01-16-2011, 05:41 PM

yeah, thats for the full distribution. My db servers are running on Centos 5.5 and thats not the issue - its the pgadmin element I need. The package that comes in the package manager is 1.10 whereas the windows version is a lot higher, and more importantly works with 9.0.2 servers.

The pgadmin/Ubuntu download is here http://www.pgadmin.org/download/ubuntu.php but only covers up to gusty and 1.8.

R2TD

stress_junkie · 01-16-2011, 06:00 PM

You can download and compile the source code.
http://www.postgresql.org/ftp/pgadmi...se/v1.8.4/src/

royster-doyster · 01-17-2011, 02:34 AM

Hi,

Thanks, I could go into the long laborious process of recompiling from source code, but why release the full package and keep it up to date on Windows, but leave one of the main distributions to fester in the past with an old version. Surely examples like this show that even the open source community supports Windows more than Linux distros themselves?

I chose Ubuntu 10.10 because it is one of the best distributions I found that anybody can use, without resorting to the command line.

I think in this instance I will have to go back to Windows 7.

Thanks,

R2TD