Operations | Monitoring | ITSM | DevOps | Cloud

In this tutorial, we'll walk you through the process of creating users both on pgAdmin, a powerful GUI tool for managing PostgreSQL databases, and the Aiven platform. User management is an essential aspect of database administration, and we'll show you how to add new users, define their roles and privileges, and configure authentication settings. Whether you're a beginner or an experienced user, this video provides a comprehensive guide to effectively create and manage users in your PostgreSQL environment.

Recording from the Open Source Data Infrastructure meetup in Berlin, hosted by Aiven and PingCAP on July 13, 2023. The video features talks by Mattias Jonsson, Senior Database Engineer at PingCAP, and Olena Kutsenko, Senior Developer Advocate at Aiven.

Discover the incredible cost optimization journey of Talon.One, a prominent promotion and loyalty solution provider.

In this tutorial, we'll guide you through the process of creating allowed IPs for PostgreSQL on the Aiven platform. Ensuring secure access to your database is essential, and Aiven provides robust security features to help you protect your PostgreSQL instances. We'll show you how to configure the allowed IPs or whitelist specific IP addresses to establish controlled access to your Aiven PostgreSQL database. By implementing IP filtering rules, you can restrict connections to trusted sources and enhance the overall security of your database. Join us as we explore the step-by-step process of managing allowed IPs on Aiven and leverage the platform's security settings to safeguard your PostgreSQL environment.

The talk is originally from the Paris Open Source Data Infrastructure Meetup, hosted by Scaleway, on June 22, 2023.

Welcome to our tutorial on executing basic queries on pgAdmin, the intuitive GUI tool for managing PostgreSQL databases. In this video, we'll cover essential SQL commands such as SELECT, UPDATE, DELETE, and INSERT, and demonstrate how to utilize them effectively on pgAdmin. Whether you're a beginner or looking to refresh your SQL skills, this tutorial provides valuable insights and practical examples. Additionally, we'll share helpful resources like SQL cheatsheets and codecademy's SQL commands article to further enhance your understanding.

Created together with Aiven, Google Cloud and IDC, this video talks about cloud-native app trends, the potential of open-source data tech, and simplified cloud data management. Don't miss out on these key factors driving developer productivity and data-driven innovation!