Just pgsql is enough. Even a chache db or sqlite do full text search

I'm not familiar with the various search features of different databases.

Do they offer things like the phonetic search that Solr does?

With Solr you can search a noun for example even if you only know how to say it and not how to spell it.