|
|
|
|
|
by pritambaral
2837 days ago
|
|
> a nightmare in postgres (users, permissions, indices creations/deletion, …). Could you expand on what you mean here? By 'users, permissions', I assume you meant management of users and access control to records at the database layer. If so, I should tell you I use database-enforced roles to manage access to various areas of the schema I manage, and RLS to protect access to records. If not, I'd very much like to know what exactly you meant. Could you expand a bit on what exactly you mean by "indices creations/deletion"? > things have changed recently, partly thanks to the Uber gate I think Logical replication in core was in the works long before Uber's post, and already available as a plugin for at least two releases at the time. I remember, because we ourselves used it (for syncing data between environments, not for upgrades) in 9.6 (the then latest release). |
|