I have not yet used it because as others pointed out I rely heavily on SQL Server 2005/8 to use Linq To SQL in my solutions. Even if I can host the application on a linux box, I still need a windows box to put the DB server on.
However, I've been looking at postgreSQL for a while and it looks ok. I am curious if anyone has tried this before.