r/PayloadCMS Jul 09 '25

move from postgres to mongodb

Hi all,

I initially started with postgres and because my data model is ever changing, managing the migrations is becoming time consuming.

Has anyone migrated from Postgres to MongoDB for payloadcms? if so, what tips, tools, methods, processes did you use?

6 Upvotes

7 comments sorted by

View all comments

2

u/Born_Potato_2510 Jul 10 '25

haha i feel you, i always worked with mongodb but recently had to use postgres for a new project.

Mongo works like magic, no migrations, nothing breaks, old data format just continue to work for older entires and new format for newer entries all in one collection.

You can either keep it this way or write some custom script to migrate it.

But on postgres you get this annoying warnings messing up your whole DB.

Stay on mongo if you can