command prompt inc, one of the companies that supports postgresql provices free hosting to free / open source projects that use PHP and postgresql.
What do you need free hosting for? If it's for a FOSS type project, you can probably find a sponsor out there to host it.
I host my own presence on the web using dynamic dns and a DSL line. It ain't fast, but I know it's up to date, and if it goes down in the middle of the night, I know exactly who to call 🙂