What does it mean when a dog’s tail stands up?

A raised tail has different meanings. When happy, dogs raise it to show joy. They also raise it when being affectionate or seeking attention, and when threatened or frightened they may raise it as a guard posture.

In short, the meaning depends on the situation, so judge by the surrounding context.