Installing phppgadmin

I wanted to use the newer Ubuntu 11.04 ,but in my work environment we are required to work with Ubuntu 10.04.

So i went ahead and installed it in my home laptop , This was meant for my personal use , hence i populated with other office environment apps(for study and research purposed) as needed apache, php5, mysql etc. That came from apt repositories.

Now when I went ahead to install phppgadmin, where i faced an unusual dependency problem where I got this error

php5-common=5.3.5-1ubuntu7 is needed and is not going to be installed.

Now i guessed that all other packages probably got updated besides php5-pgsql , and hence broken dependency

So like any other curious cat i decided to do google it.

In my previous attempts of getting older packages I had found out that in apt-get commands if you mention the package name specifically then it gets that exact version.

although i never got around to actually understand and use it, Since this was my personal laptop , so decided to experiment with it. Finally I did

sudo apt-get install php5-common=5.3.5-1ubuntu7

And boy , was I surprised ,This command got the required comman pacakage but removed all other packages like phpmyadmin along with lots of other packages which left my php install in ruins.

Breaking my install of php module and the other dependent softwares too. Which hung up on me requiring to restart apache and this would not happen since mod-php broke during my attempt to get what i want.

Now neither i could remove or install anything in php , since any such actions would require apache to restart, which it would not since phpmod.so went missing

After scratching my head for a while i understood the problem and ,

I simply went ahead and disabled mod-php5 by

sudo a2dismod php5

Which allowed my apache to restart and post-install scripts which block my apt install commands to complete

Immediately following this, I fired purge of packages including phpmyadmin which now worked.But still my php remained in ruins.

Now i went ahead and got all the packages back, which (surprisingly to my horror) still did not repair my apache mod.

Again after a lot of head scratching and complaining , I realized that some dependency is still broken upon research i came across some search results and got the package name needed , which i used in following command

sudo apt-get install libapache2-mod-php5

After this i fired commands to get rest of needed packages to get my system upto speed, including

sudo apt-get install phppgadmin

Now you may feel it's still not working restart the system , it may take a while but it works

Note: phppgadmin is still not released for pgsql database server 8.3+ , neither has a php-pgsql package released for newest version( hence need to downgrade the php install). { This note is a deduction and i can not ascertain accuracy of this information }