How hard is it to migrate from MySQL to postgresql?

Question

MySQL

1. Are they similar?
2. What would you advise to smoke in this direction.
3. Is it worth switching at all.
Thanks to.

Answer 1

1. Are they similar?

under the hood - strong

2. What would you advise to smoke in this direction.

the basic syntax is the same. Everything else is googled with half a kick

3. Is it worth switching at all.

yes, definitely.
The tool is very flexible, from a database for a business card, to a highload, from a map service, to NoSQL.
You can make your own field type, index, write in python, C, Lua
Brief overview
https://events.yandex.ru/lib/talks/2324/

Answer 2

1. yes and no
2. official documentation seems to be good
3. depends on the goals pursued