dumping puppetdb and then restoring it on a postgres server

edit

HI,

I am able to do a dump_all and then re create the databases onto a vanilla postgres server, I am however encountering some error messages during the restore, all this is documented here: http://pastebin.com/2kqH5as6

Please advise.