Page makes a good point about not overdoing the cheerleading. Please read this excellent article on what is currently known about supporting, praising, and motivating children, based on actual studies and real results rather that the 'common wisdom.' How NOT to Talk to Kids, by Po Bronson: http://nymag.com/news/features/27840/
My own experience is that every child is born with his/her unique personality (you'll see this is also true if you watch a boxful of puppies or kittens, too!). Some are bold and adventurous, some extremely timid, some are leaders, some followers, some are independent loners, some like to carefully evaluate a situation before wading in. That basic personality is what you've got to work with, and hopefully a parent will find a respectful and realistic way to do this.
I was born cautious and watchful, and as the oldest of 4 girls, my mother pushed me constantly to be the groundbreaker, the leader, the guide for my younger siblings. What a poor fit that was for me. I remember her telling me constantly things like "Just get in there are do it! Of course you can! Nobody's going to bite your head off! Be brave! What's the matter with you? Make your mommy proud! Your sisters are counting on you! You KNOW you can do this! Don't be such a sissy! I expect so much more of you."
And on and on. I was married and divorced and well into my 30's by the time I realized I was not the person my mother "created," and have been finding out ever since who I actually am (now in my 60's). And I am non-assertive, cautious, shy, and definitely oversensitive, a bit fragile, both emotionally and physically. And all that is okay, because I'm also creative, imaginative, serious, able to apply myself to topics of interest, good-natured, strongly spiritual, trusting, able to see the big picture (can't tell you how many people have called me "visionary"), patient, and other worthwhile qualities.
I hated myself and my life as a child. Being me was a constant strain, and I woke up dreading each day. I'm so much happier now that I can be myself, and am surrounded by people who care about the actual me.
So I hope you can find a way to come to terms with your child's individual qualities. Support them without overblowing them. Notice and appreciate when your child does well, but don't insist he/she do more or be more than he/she is. Your child will very likely have a happy and accomplished life.