Timeline for PostgreSQL 11 - Can I turn a schema into the wild west?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 20, 2023 at 0:24 | comment | added | J. Gwinner | @MikeSmith It's MariaDB, not Postgres, but here's the fix for lacking SUPER on RDS for a database restore: dba.stackexchange.com/questions/317922/… | |
| Jan 20, 2023 at 0:23 | comment | added | J. Gwinner | @MikeSmith In practice, I've found that "SUPER" isn't a killer, the RDS permissions give you pretty much everything you'd need to do except some esoteric stuff relating to read only database setup, and restoring views (not so esoteric). I found a work around for the restoring view problem. | |
| Jun 14, 2022 at 0:37 | vote | accept | Mike Smith | ||
| Jul 16, 2021 at 17:35 | comment | added | Mike Smith | Good to know. I do not have administrative permissions to our Amazon account so I was unaware of that restriction. I will modify my suggestion to limit that suggestion to a server on our local network where we have complete control of the database. | |
| Jul 16, 2021 at 16:46 | comment | added | Laurenz Albe | You won't get a superuser on a hosted database... | |
| Jul 16, 2021 at 15:09 | comment | added | Mike Smith | Thank you Laurenz. That is what I suspected. I felt I had to check because my boss was insistent that what he wanted was possible. I will let him know it is, but not where he wanted it. He will need to spin up a new Amazon RDS for the development database so having everyone as a superuser does not endanger my production database. | |
| Jul 16, 2021 at 15:02 | vote | accept | Mike Smith | ||
| Jun 14, 2022 at 0:37 | |||||
| Jul 16, 2021 at 11:22 | history | answered | Laurenz Albe | CC BY-SA 4.0 |