migrated to postgresql and updated specs