Pgroll: zero-downtime, undoable, schema migrations for Postgres

Re:Pgroll: zero-downtime, undoable, schema migrations for Po... by surjection on Tuesday October 03, 2023 @01:19PM (#37754812)

You're right. I wish schema wasn't such an overloaded term :)

In order to access either the old or new version of the schema, applications should configure the Postgres `search_path`[0] which determines which schema and hence which views of the underlying tables they see.

This is touched on in the documentation here[1], but could do with further expansion.

[0] - https://www.postgresql.org/docs/current/ddl-schemas.html#DDL... [1] - https://github.com/xataio/pgroll/blob/main/docs/README.md#cl...

[ Parent | on HN ]

Re:Pgroll: zero-downtime, undoable, schema migrations for Po... by dkubb on Tuesday October 03, 2023 @04:29PM (#37757116)

I mentally change schema to namespace when thinking about the postgresql feature.

[ Parent | on HN ]

Re:Pgroll: zero-downtime, undoable, schema migrations for Po... by guffins on Tuesday October 03, 2023 @04:41PM (#37757256)

You’re not alone. That’s also how PostgreSQL itself thinks about schemas! https://www.postgresql.org/docs/current/catalog-pg-namespace...

[ Parent | on HN ]