The postgres layer in cdash relies on some of the features of the mysqlcompat package: http://pgfoundry.org/projects/mysqlcompat
The following patch to the mysqlcompat package is required to use it with recent versions of PostgreSQL: http://public.kitware.com/Wiki/images/d/d0/Mysqlcompat.txt
(Note that this *is* actually a patch file, but the CDash wiki doesn't allow upload of files ending with ".patch".)
Installation on Ubuntu
apt-get install libsql-translator-perl
Then run the script
Warning The indexes generated by the script are all the same so you would need to pre-append the table name.