[cname]

Anecdotal, but PostGIS is the reason I started using Postgres several years ago in some of my own projects, which later came in handy at different jobs. At one place, we standardized on Postgres partly because of PostGIS.

I think Django has had some influence too, since they've always recommended Postgres.

[Boothroid]

I selected PostgreSQL for a geo project recently. Still haven't got my head around tuning, but apart from that I've found it great to use. I use psycopg2 to connect from Python. No nasty surprises in use, and found that all my pidgin SQL translated easily. Also worth knowing that ogr2ogr supports PostgreSQL and is an awesome tool.