Its been the trac so far ......

Ever since the WBS in my previous blog there have been changes in the working procedure :

I moved completely to trac that has proved to be very convenient for me so far. I have been able to do every thing using the TRAC . Access my repository, keep on tack with milestone and set my timelines etc . This blog was not much useful henceforth .

Experience so far :
-----------------

The fact that I used the Git repository to take regular backups during this project, has given me confidence to experiment with server internals . Yesterday I actually realized the importance of the back ups when my server crashed and I had forgotton to take a PG_Dump of my current state of database. But reverting back was easy because of my backup on repository.

The process of Server Crash recovery has been an interesting experience is another option that I will be adding in my documentation . Though I have learnt to reset the required errlog , there seems to be one basic problem ....The existing tables in the database loose all their internal data . I am still trying to restore back to old data.

I had earlier come up with 2-3 basic regression test cases apart from the already present regression test script present as a part of the server. Creating a regression cases was an interesting experience by itself. It involved feeding some sql queries , building tables, dropping tables , adding and deleting rows . They all seem to work on the reinstalled server.

After code changes , there is big process of bulding (changed files) , reinstalling server , starting the server , reloading the database of old one to the new database. It took a couple of attempts abour 4-5 hrs to complete this stage .

For all the actions on server, going through postgresql documentation might have seemed useful to far .

I am now trying to come up with a script file to automize the server build after code changes .

The changes are visisble after the explain analyze feature is chosen to be printed on GUI.


More Later...

Work Breakdown Structure

Project Name : Expalyze

Project : Explalyze [ Derived from Explain Analyze]

Goal : To perform enhancements to Explain Analyze feature/tool of Postgresql.

Requirement/Plan status : In the process .

Blog testing ......!