If using fresh pumpkin or squash the trick is to roast the pumpkin (remove the seeds) and once its cooked set it into a fine mesh colander with a dish underneath to drain the excess water. You might need to compress it a bit (push it softly with a wooden spoon) to remove a bit more water.