Promo-SM

In the PaaS AWS, Aurora will take the control

Buying RI doesn’t give you the guarantee you will have a reserved capacity…

That might be true, but which system/service allows you to enter password with 0 delay inbetween entering passwords and have 0 input and server latency? If we really consider any real world scenarios, cracking a password is pretty much impossible. Though I still hope people would start using password managers, and hopefully websites start letting me use more that just 10-15 characters. I just want to crank it to the full 128-characters and be done...

Hi sir, how to do troubleshoot if conversions didn't happen

I'am issuing same etcdctl command to get kay-value, but nothing returning. What can be problem

Interesting topic, thanks for the presentation.

Hi can you share the query that you have used either in github

Can you please paste the script here? that polls for the primary node continuously?

Your explanation simple yet superb , Kindly share the document

00:05 Passwords may appear in Postgres logs when creating new roles or users. 00:34 Postgres logs can expose sensitive passwords. 01:06 Reset PG start statements and create a test role 01:46 Logging all or ddl statements can expose passwords in Postgres logs. 02:25 Sensitive passwords appearing in Postgres logs 03:00 Passwords appearing in PG statements is a security issue 03:30 Mitigate the risk of storing plain text passwords in Postgres logs 04:08 Postgres logs can store plain text passwords.

Do i have to take a downtime during switchover if i randomly wanted to switch one node and remove it

Hi can you you make a vedio for pgpool ssl configuration.

🎯 Key Takeaways for quick navigation: 03:35 🤖 Patroni handles node failures and failovers internally. 04:19 🛡️ A demonstration of simulating a primary node failure and leader election in Patroni. 07:28 💼 How to perform a planned leader switch-over in Patroni. 09:22 🤖 Introduction to etcd commands for Patroni configuration and monitoring. Made with HARPA AI

🎯 Key Takeaways for quick navigation: 00:01 🤖 Introduction to Patroni and its reliance on DCS (etcd) - Patroni is a Python-based bot used in PostgreSQL clustering. - Patroni relies on a Distributed Configuration Store (DCS), like etcd, for coordination and leader election. 03:35 🛡️ Overview of Node Failure and Failover in Patroni - When the primary node fails, a new leader election process is triggered. - Replicas check the status of other nodes, and the one with the least replication lag becomes the new leader. 04:19 💼 Demonstration of Node Failure and Leader Election - The TTL of the leader key counts down, and the first replica to acquire it becomes the new leader. - Demonstrates the leader election process when the primary node fails. 07:28 🛡️ Planned Leader Switch Over in Patroni - Shows how to manually switch the leader in a planned maintenance scenario. - Node 1 is promoted as the new leader using the "switch over" option. 09:22 🤖 Introduction to etcd Commands - Introduction to etcd commands used for Patroni configuration and monitoring. - Demonstrates commands like "get leader key value," "get configuration," and "get member details." Made with HARPA AI

thanks

where is part2?

So if a table is 1TB size then we will see 1024 files in disk? Isn’t that too difficult to maintain?

where is part2?

How do we know about this seminars that you are conducting online ??

Very interesting

Where is the document ?

Very useful examples, thanks for the demo!

This is a great video. Thanks for this.

hi Does the clone database also replicated the data from the source after its creation or its a database from snapshot at that point?

thanks 😉

Can we change this segment value? Does it have any effect on performance? Cuz postgresql is operating on 8kb pages by default

Very informative, thank you for sharing this.