I wrote StarQueue https://www.starqueue.org which uses Postgres as a back end.

I actually wrote StarQueue for MySQL, Microsoft SQL server and also Postgres - they all work just fine as a message queue back end, because they all support SKIP LOCKED.

I started out including Oracle as a supported database but found that I loathed Oracle's complexity.