Operations | Monitoring | ITSM | DevOps | Cloud

July 2023

Creating Allowed IPs

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.

Getting Started with SQL Queries

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.

Creating Databases, Schemas, and Tables on pgAdmin

In this tutorial, we'll walk you through the process of creating databases, schemas, and tables on pgAdmin, a powerful GUI tool for managing PostgreSQL databases. Whether you're new to pgAdmin or seeking to enhance your database administration skills, this video provides a comprehensive guide to efficiently create and organize your database structures. We'll also highlight the seamless integration of pgAdmin with Aiven's PostgreSQL service, enabling you to leverage Aiven's reliable and scalable infrastructure while utilizing pgAdmin's intuitive interface.

Creating Databases, Schemas, and Tables on pgAdmin

In this tutorial, we'll walk you through the process of creating databases, schemas, and tables on pgAdmin, a powerful GUI tool for managing PostgreSQL databases. Whether you're new to pgAdmin or seeking to enhance your database administration skills, this video provides a comprehensive guide to efficiently create and organize your database structures. We'll also highlight the seamless integration of pgAdmin with Aiven's PostgreSQL service, enabling you to leverage Aiven's reliable and scalable infrastructure while utilizing pgAdmin's intuitive interface.

Optimizing Cloud Infrastructure: Strategies for Short, Mid, and Long Term Success with Talon.One

In this video, we have a special interview with Yotam Cohen, DevOps Team Lead at Talon.One, who shares insights on how they optimized their cloud infrastructure costs with Aiven's managed services. Discover how Talon.One, the leading promotion and loyalty solution, manages more than 250 databases totaling 17TB in size, while ensuring optimal resource allocation for each customer. With Aiven's standardized PostgreSQL plans, they were able to achieve cost efficiency without compromising performance and scalability.

Connecting PostgreSQL to pgAdmin

In this tutorial, we'll guide you through the process of connecting PostgreSQL to pgAdmin, a popular GUI tool for managing PostgreSQL databases. Whether you're a beginner or an experienced user, this video will provide you with step-by-step instructions on establishing a seamless connection between PostgreSQL and pgAdmin. Additionally, we'll showcase how Aiven's PostgreSQL service seamlessly integrates with pgAdmin, enabling you to efficiently administer your database.

Getting Started with PostgreSQL: Setup Postgres Service

Welcome to our introductory video where we focus on setting up the PostgreSQL service on Aiven. In this tutorial, we'll guide you through the initial steps of creating and configuring your PostgreSQL database on the Aiven platform. While this video primarily covers the setup process, we have exciting plans for future videos where we'll dive into connecting with a client and exploring advanced functionalities. Stay tuned for upcoming episodes that will help you make the most out of PostgreSQL on Aiven. Subscribe now and join us on this journey as we unlock the full potential of PostgreSQL in conjunction with Aiven's managed services!