Can't push migrations to Atlas Cloud

[KostyaZgara]

Can't push migrations to Atlas Cloud

[masseelch]

atlas migrate push is computing some intermediate states for the migration files. I have a feeling that there might be something off inside there. I will investigate and come back to you.

[masseelch]

Okay, we managed to figure this out:

Extensions in PostgreSQL are database objects, they cannot be managed in schema level. This means your migrations should work in database scope (without search_path set).

In your example, if you remove the schema = "public" form the docker block in the atlas.hcl it should work in CI.

Please note, that by changing the scope (schema bound to database bound) your migrations will have schema qualifiers.

[giautm]

@KostyaZgara I saw my co-worker's response here. #2578 (comment)

Please use a bare docker image for PG (without Postgis installed on it). postgis/postgis:15-3.4 replace this image with regular docker image, and remove the baseline for drop extension.

[KostyaZgara]

Yeap, it works! Solution with removing search_path and schema = "public" from docker block in atlas.hcl works and now I can be able to run extensions everywhere locally, in CI, and in production. Moreover Atlas can compute now diff and install extension automatically that's great news as well, cuz now I can remove manipulations with baseline scrips everywhere. I'm closing the issue now, but I think it would be great to add such mention in documentation, cuz it's not obvious behavior in my opinion. Thanks!

[masseelch]

Yes. We will improve the documentation regarding this. Glad we could help.