Different problems, but vendor lock-in isn't really one of them imho. If you are skilled enough to setup pg instead of using RDS you can always move off it to systems under your control.

If you don't have the skills, you can migrate to another provider like Heroku.

As far as my experience, they aren't extending PG in non-compatible ways.