Develop, Maintain and Manage.........

In software life cycle, we are having phase from development to Maintenance. It's realistic for almost all in life. The merely approach to keep going anything adjacent to beatings of time is by intentionally running in the direction of maintaining it. Maintaining involves correcting the errors, repairing the breaks and guarding against insatiability. My father always used to articulate me that  there is a lot of great effort while developing something as well as maintaining it but there is a small instance enough for destroying whole .For you will see that every great fall had either of these factors playing some result.

If you fail to maintain what happens? When you don't correct the errors, these small small things will keep growing and emerge into an untalked monster. When you don't repair the parts that start to break apart, the crack starts moving towards the fundamentals. Once you lose on the foundation, it's just waiting for small blow to fall down into pieces. It is also applicable for the trust also. No matter how good person you are in your ongoing living. If any miserable happens it doesn’t take to quaking also.

But still there is a good importance of term Manage. This helps a lot while in this situation managing such as shielding or getting busy in some feel free things. There is need to carry it in your heart or to make it a partner in your journey. But still it will be in your heart and will be transform it to your permanent memory that how you managed the thing and what things come across. Cycle is simple and goes on. Avoid as much as possible. But in case you meet them again then do judgment, boost your understanding base and with a trust of never meeting it again :)

Special Note: There were no blogs available of April and May. I think I was thorough the meaning of these software terms Development, Maintenance and Management also

“Woman’s Day Special”

Best woman in my life and award goes to..... "My MOM"(Aaai ga)

Hmm we used to say (Aaai ga) whenever we are in pain (mostly Marathi people use this). But in my case I always used to remember her in every time in my pain as well in my high spirits moments. I really remembering my days since my childhood to the till date.

When I was so small my mom was working. All the way she was not with me for whole day. I used to cry when she were about to leave home for her work. But she was like showing me that she will come in few minutes. Now as I m grown up now I can feel her emotions what she had suffered while leaving her beloved child. But yes yes.. Now I am realizing, what the pain she had taken for taking care of girl like me. But still I m sure she never said like word “Aai ga”. What is the reason I really don’t know. How can be someone so broad kindheartedness?

My mother was passionate about me and was articulated by helping me to engage in many house hold things, many activities like singing, complex, and flexible activities that helped me to  learn, express myself, and play well with others, apart from our studies.

As for my further studies after 12^th I moved to other station from my hometown, in few days after I felt a lot. But I decided to be not so much emotional. Come across the reason why you are here, but really god promise some way I can’t be so much practical. Whenever for someday I used to go for vacations to hometown I used to roam outside till the time. But after 7 P.M a sure shot call had found that where r u? When u r coming back to home? At that time I never realized the importance of that call but after vacation gets over and I return back from hometown. When I was outside after 7 P.M ,A sure shot drop of water had arise from my eye with the view  that today still 7 P.M. but no call from mamma. Really at that time a word mumbled by me “Aaai ga” I m really missing you, really missing your call!

Once I met with an accident of my scooty , from that day I was having fear of not to drive the scooter. But when she realized that I am not driving the scooty because of that fear. In spite of the accident had done by me she had asked me to escort her to her workplace with scooter. At that moment she never realized to me that she wanted to eliminate my fear. But when she came back to home at the same day, she asked me how u feels after so much long time driving? At that moment I realized she had done that just to take away my fear. She is like that she will do the things for some intention for you but you will come to make out this last, after the movie gets over. And I will be like “Aaai ga” I can’t make out this thing what she had done for me. In some way she was unpredictable for me.

And many more things are there to tell about her. Because I think life is full of her presence and as I can’t also summon up all the things in such small blog for that I should write blog of memories till lot of years ahead. But really I will thank god by anyway that giving me such a nice AAI (MOM) to me. And I know I can’t give her in back of this. On the occasion of Women’s day especially I will show appreciation to my mom for best woman in my life.

Happy Woman’s Day!!!

PostgreSQL-Backup-Automation-Steps

 Environment

Operating System	RHEL 5.5/CentOS 5.5
Database	PostgreSQL 9.1

Assumptions

Details of Database Server Machine

Server IP	192.168.0.1
PostgreSQL Installation (bin) Directory	/var/lib/PostgreSQL/9.1/bin
Data Directory (initdb)	/var/lib/PostgreSQL/9.1/data
Configuration Files Location  (postgresql.conf, pg_hba.conf)	/var/lib/PostgreSQL/9.1/data
PostgreSQL Owner OS User	postgres
Postgres Database Super User	postgres

Details of Backup Server (Server for NFS sharing)

Server IP

192.168.0.2

Sharing/Exporting directory on to another Linux machine

 Server Side Configuration (On NFS Server )

1.       Login as root user

su -

2.       make directory (assumed path /var/lib/PostgreSQL/9.1/)

mkdir db-backup-1

3.       Edit /etc/exports

vi  /etc/exports/

4.       add following line into 'exports’ and save the file

/var/lib/PostgreSQL/db-backup-1 *(rw, sync)

5.       Restart NFS service

/etc/init.d/nfs restart

Note: NFS must be listed as exception in Firewall

Client Side Configuration (On Database Server)

6.       Create a directory to be mount on shared directory at server

cd /mnt/

mkdir db-backup

7.       Mount the directory to the shared directory by executing following command

mount -t nfs 192.168.0.1:/var/lib/PostgreSQL/db-backup-1 /mnt/db-backup/

8.       Add following line into the /etc/fstab file and save it (as root user) to enable auto-mount at system startup

192.168.0.2:/var/lib/PostgreSQL/db-backup-1 /mnt/db-backup nfs defaults 0 0

Creating a cron job to automate daily backup at shared directory at backup server

1.       Create a directory for SQL backup within mounted directory

su - postgres

cd /mnt/db-backup/
mkdir sqlbackup

2.       Create a shell script with following commands and save it as ‘daily_backup.sh’
within data directory (or anywhere where postgres user has appropriate permissions)

vi /var/lib/PostgreSQL/9.1/data/daily_backup.sh

Add following command in the file (To take backup and include Current Date and Time in the dump file name)

/var/lib/PostgreSQL/9.1/bin/pg_dump -U jnk_ee_dba  empexchangedb > /mnt/db-backup/sqlbackup/$(date +"%Y-%m-%d_%H%M")_empexchangedb_jnk_ee_dba_16.sql

Save and exit the file

3.       Set authentication method to trust (without password) for backup user of database

vi /var/lib/PostgreSQL/9.1/data/pg_hba.conf

Add following line in the list authentication file

# TYPE   DATABASE                USER              ADDRESS     METHOD
local    sampledb                dbuser                         trust

Save and exit the file

4.       Reload the Postgres configuration

/var/lib/PostgreSQL/9.1/bin/pg_ctl –D /var/lib/PostgreSQL/9.1/data reload

5.    Make a cron job entry for time of backup as follows 

crontab –e

Add following line

35 5 * * * /var/lib/PostgreSQL/9.1/data/daily_backup.sh

Save and exit the file

Daily Backup Script will be executed at the specified time and backup will be done at shared directory of backup server.

A Lesson of Security

The day I was in SBI at my hometown branch for some bank stuff. A long queue was there for depositing money, withdrawing money and bla bla. I was like a just a part of that queue. But suddenly I looked at a facility Green Channel Counter. So I move ahead from the queue and try to understand it carefully. It was just like operation done at ATM centre with the ATM card. This novel facility would be a game changing move by reducing process time, as duplication in writing/feeding account details and transaction details by the customer as well as the person behind the counter is avoided by simply capturing these details by swiping the SBI Shopping cum ATM Card on a device available at the Single Window Operator's (SWO) counter. At the Green Channel counter, there is a Point of Sale Machine (POS), on which the customer swipes his card. He is then asked by the machine to select the type of transaction, viz. (0) Cash Deposit, (1) Cash Withdrawal and (2) Funds Transfer. Once the customer selects the type of transaction by entering the option, the message ‘Enter the Amount’ is displayed. The customer is asked to confirm the input amount followed by a message “Please Enter the PIN’. When the PIN is entered by the customer, the transaction gets transferred to the terminal of SWO who after entering the denomination of the cash to be paid / received, pays / receives cash and the transaction gets completed. Hush so now I finished with Green channel awareness lecture. he he he .....And finally by using these facility I finished with my bank transaction and I was about to move from that place.

At my behind one uncle was looking what I m doing and how would I finished my work in very less time where as I was in last of queue but got work done early. Uncle was from the rural side. They came towards me and asked me "muli he kay ahe?" (My girl, what is this thing?). I explained them every thing but they only get cleared with theoretically not practically. The also wanted to finish off there work like me and wanted get off early. They again asked me "Majhyakade pan ATM card ahe tu mala madat karshil ka?" (I also having an ATM card can u please help me?). Being an AADARSH NAGARIK (Good citizen) I said them yes sure ! And I asked to swipe the card. They swiped.but they can’t managed. Finally I swiped and it gets done. I ask them to please enter the PIN number. As they had written it to one paper in there pocket. Now in this stage I got something surprised first. How can anybody write the PIN to some paper? But the height was ahead; they had shown me that paper and asked to enter. I told them u can enter. But he was like said its ok I am telling you u just feed it. A queue of 15-20 people including me and bank counter person were hearing that PIN number with the loud voice of that uncle. Now what to do? A person was not aware of  that how much a PIN number is important. They finished off with there transaction and we both came out side. I told uncle that uncle PIN number should not be revealed it should be known to only you, nobody else.

Moral of the story was that, some people are there who are not so much bother about the importance of PIN numbers and passwords. As I m the IT person I am aware of that how cyber crimes can be happened but what about these people? Now Security is very important aspect in banking sector. Not in banking it is actually important in all fields but is it really like people like these uncle are well attentive with these things? I think this uncle have got a lesson of security. What about others?

According to me:

Solution:

JAGO NAGRIK JAGO

Or

A step for Biometric Identification System with smart card

Rural poor people frequently lack an "identity" that allows them to access credit. Banks are reluctant to provide services to these potential customers, who are often illiterate and have no credit history. As the person will be there identity no need of carrying any password or PIN. Just swipe any smart card, give your identity that’s it transaction gets done. I know as I am proposing this solution there is having prons as well cons. But every thing has two sides what we can do? Just fine-tune with requirements what else we can do?