In Hebrew, the first "Lord" is Yahweh (God's name), and the second "Lord" really means Lord. So the text is "Yahweh said to my Lord."
The way Peter uses the words in Acts 2:34 seemseems to indicate that the second Lord is the Messiah. This is also corroborated by Matthew 22:42-45.