Accediendo a nuestra base de datos Postgres

Curso Práctico de AWS Cloud

Introducción al cómputo en la nube

¿Qué es el cómputo en la nube?

¿Cómo puedo empezar a usar AWS?

Introducción a la oferta de servicios de AWS y sus aplicaciones

Introducción a la oferta de AWS y sus interacciones

Ejemplo de arquitectura con Elastic Beanstalk

¿Qué es Amazon EC2?

Creando una instancia de EC2

Conectándonos a nuestra instancia desde Windows

Conectándonos a nuestra instancia desde Linux

Conectándonos a nuestra instancia desde OSX

Subiendo un proyecto: Clonando un repositorio de GitHub a nuestra Instancia de EC2

Subiendo un proyecto a nuestra instancia de EC2: Ejecutar nuestro proyecto

¿Qué es Lambda y Serverless?

Creando una función Lambda

Elastic Beanstalk

Conociendo Elastic Beanstalk

Creando un ambiente en Elastic Beanstalk

Almacenamiento - S3

Almacenamiento con S3: Contenido Estatico

Almacenamiento con Glacier: Contenido duradero

Bases de Datos

Bases de Datos - RDS Aurora PG

Conociendo RDS PG

Creando una base de datos Platzi DB

Haciendo una migración a RDS PG

Conociendo Aurora PG (Postgres)

Haciendo una migración a Aurora DB

Mejores prácticas de Bases de Datos y RDS

Redes

Redes - Route53

Herramientas de administración

Herramientas de administración - IAM

Utilizando IAM

CloudWatch

CloudTrail

Seguridad

Certificate manager

GuardDuty

Bonus

AWS Rekognition

Creando nuestro servicio de Postgres

Accediendo a nuestra base de datos Postgres

Cierre del curso

Conclusiones del curso de Fundamentos de AWS Cloud

You don't have access to this class

Keep learning! Join and start boosting your career

If you already have an account,

Resources

How to connect to an RDS instance in Postgres?

Connecting to an instance of RDS (Amazon Relational Database Service) in Postgres may seem complicated at first, but with the right steps, this task becomes simple. In this section, you will learn how to make this connection and verify the data needed to do so.

To begin, log in to the Amazon console and navigate to your RDS instance. Here, in the "Connect" section, you will find an "endpoint", which is essential for your connection.

Software Download:
- Download and install PGAdmin, a graphical administration tool for Postgres databases.
Configuration in PGAdmin:
- Use your instance name, username and password that you set up in Amazon RDS.
- Copy the endpoint obtained from the console and configure it as the host in PGAdmin.
- Make sure you use the correct port (usually 5432) and the database you want to connect to.
Common errors when connecting:
- If you experience errors, a frequent cause is that the server is not listening on the indicated port.

How to modify your instance configuration to allow connections?

To facilitate external connections to your RDS instance, it is necessary to modify certain settings that initially restrict connections only to the Amazon network.

Make the instance public:
- In the RDS console, select the instance and choose the modify option.
- Change the settings to make the instance publicly accessible.
Edit security group:
- Use the security group of your instance to allow connections from external IP addresses.
- In the "Inbound" section, modify the rules to allow connections from any IP or limit to specific addresses for added security.
Monitor changes:
- Reload the console page to verify that the changes are applied and that the database is now accessible.

How to create and manage SQL tables in PGAdmin?

Once the connection to your database is established, the next step is to start creating and managing tables, which is done using SQL (Structured Query Language).

Open the SQL editor:
- Use the SQL icon in PGAdmin to open a window where you can enter commands and execute queries.

Creating tables:

Copy and paste the SQL script needed to create a new table. A basic example:

CREATE TABLE films ( code CHAR(5), title VARCHAR(40), did INTEGER, date_prod DATE, kind VARCHAR(10), len INTERVAL HOUR TO MINUTE);

Data insertion:

Once the table is created, insert data using the following type of query:

INSERT INTO films (code, title, did, date_prod, kind, len)VALUES ('12345', 'Movie name', 1, '2023-10-12', 'Drama', '02:00');

Data query:
- To verify that the data was inserted correctly, use a SELECT:
```
SELECT * FROM films;
```

Remember that constant practice and familiarity with SQL will help you efficiently manage your databases in RDS. Don't hesitate to consult additional resources or more detailed tutorials to further advance your skills, go ahead and improve your database proficiency!

Contributions 37

Questions 2

Sort by:

Want to see more contributions, questions and answers from the community?

Héctor Daniel Hernández Castillo