Psalm 92 (Greek numbering: Psalm 91), known as Mizmor Shir L'yom HaShabbat, is a psalm ostensibly dedicated to the Shabbat day. Though it is permissible to recite it any day, it is generally reserved for Shabbat and is also recited during the morning services on festivals.
Psalm 92 is recited three times during all of Shabbat:
Part of Kabbalat Shabbat. This recitation officially ushers in the Shabbat.
During Pesukei Dezimra.
The song of the day in the Shir Shel Yom of Shabbat.
This psalm is also recited on a Yom Tov that occurs on a weekday.
Verse 1 is part of Mishnah Tamid 7:4.
Verses 1-2 are part of Likel Asher Shabbat recited in the blessings preceding the Shema on Shabbat.
According to the Midrash, Psalm 92 was said by Adam. Adam was created on Friday, and he said this psalm on the onset of the Shabbat. It is not a psalm that speaks about the Shabbat, but one that was said on the Shabbat. this was Adam's first day of existence and he marveled at the work of the Creator.
Psalm 92 was set to music by Franz Schubert for Salomon Sulzer (D 953).
The Requiem Ebraico (Hebrew Requiem) (1945) by Austrian-American composer Eric Zeisl, a setting of Psalm 92 dedicated to the memory of the composer's father "and the other countless victims of the Jewish tragedy in Europe," is considered the first major work of Holocaust commemoration.
Mark Alburger composed a musical setting for Psalm 92 as well.
