superuser | Postgres.FM 088 |

  Рет қаралды 204

PostgresTV 💙💛

PostgresTV 💙💛

3 ай бұрын

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try KZfaq's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss the superuser role in Postgres - what it is, how and when it shouldn’t be used, and whether most cloud providers are right to not give us it (no prizes for guessing).
Here are some links to things they mentioned:
* superuser (docs) www.postgresql.org/docs/curre...
* Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG) www.crunchydata.com/blog/crun...
* Supabase docs (unsupported operations) supabase.com/docs/guides/data...
* Crunchy Data docs docs.crunchybridge.com/concep...
* RDS docs docs.aws.amazon.com/AmazonRDS...
* Cloud SQL docs cloud.google.com/sql/docs/pos...
* Azure docs learn.microsoft.com/en-us/azu...
* Roles, Privileges, and Security (talk by Ryan Booz) • For Your Eyes Only: Ro...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the uncut version, with video. Check out Postgres.fm to find audio-only podcast episodes, edited for convenient listening.

Пікірлер: 2
@obacht7
@obacht7 3 ай бұрын
Quite philosophical this time. Reminds me of "free as in freedom" vs. "free as in free beer". I will add "you only own what you can destroy" to my list of quotes worth remembering 👍 For me, the podcast is perfect for listening without video. I enjoy every episode!
@maudrid
@maudrid 3 ай бұрын
I think that there's a flaw in how postgresql treats superuser. Some things only super user can do. Why not allow me to assign permission to a user that I want to allow to refresh a subscription for example. Now this user has to be a superuser. I've had to write functions that are just wrappers do specific things with execution rights of the superuser.
Health check | Postgres.FM 089 | #PostgreSQL #Postgres podcast
40:49
PostgresTV 💙💛
Рет қаралды 293
transaction_timeout | Postgres.FM 087 | #PostgreSQL #Postgres podcast
26:48
Osman Kalyoncu Sonu Üzücü Saddest Videos Dream Engine 170 #shorts
00:27
КАРМАНЧИК 2 СЕЗОН 7 СЕРИЯ ФИНАЛ
21:37
Inter Production
Рет қаралды 473 М.
Sridhar Ramaswamy, CEO, Snowflake | Data Cloud Summit 2024
19:17
SiliconANGLE theCUBE
Рет қаралды 9 М.
Don't do this | Postgres.FM 091 | #PostgreSQL #Postgres podcast
44:31
PostgresTV 💙💛
Рет қаралды 512
Asking Doctor Mike About Health in Technology
1:23:05
WVFRM Podcast
Рет қаралды 863 М.
DHH - Ruby on Rails, 37signals, and the future of web development
1:09:57
MongoDB Internal Architecture
43:25
Hussein Nasser
Рет қаралды 82 М.
Match & Replace - HTTP Proxies' Most Underrated Feature (Ep. 76)
1:34:43
Critical Thinking - Bug Bounty Podcast
Рет қаралды 1,7 М.
Rails + Postgres | Postgres.FM 086 | #PostgreSQL #Postgres podcast
45:23
PostgresTV 💙💛
Рет қаралды 313
ToRung short film: 😭i'm not blind😢
0:58
ToRung
Рет қаралды 109 МЛН
Vampire Girls FIGHT Over Boy 😈
0:32
Alan Chikin Chow
Рет қаралды 10 МЛН
Сначала скажи, а потом не мамкай 🗿 #shorts
0:16
Вика Андриенко
Рет қаралды 2,2 МЛН