First of all, if you’re not interested in management, don’t do it. If you’re better at the day-to-day functions of the library (or whatever organization you work in), do that.
But if you are interested in management, or think you might be, go for it. AND, if it turns out you’re not good at managing or don’t like it, there’s no shame in returning to a non-management position.
To assist you, Letters to a Young Librarian has some tips—things that she’s learned from being a manager. In some ways, I think her advice about being “relentlessly cheerful and cheerfully relentless” pretty much sums it up.
You could probably add to this list, so please hit me with your tips in the Comments.