Re: Where to learn PostgreSQL for free?

Поиск
Список
Период
Сортировка
От S Hoffman
Тема Re: Where to learn PostgreSQL for free?
Дата
Msg-id E70F2E8F-B1BE-4C29-A559-B67462912A65@gmail.com
обсуждение исходный текст
Ответ на Where to learn PostgreSQL for free?  (Edwin UY <edwin.uy@gmail.com>)
Список pgsql-admin
Good morning, Edwin,

I understand your concerns about security, especially with your previous experience on the AWS Free Tier. It’s
essentialto approach this with a strategy that enhances security while using AWS or any other cloud service. Here are a
fewsteps to help you safeguard your environment: 

    1.    Strong Access Controls: Always use strong, unique passwords for your AWS account and databases. Implement
Multi-FactorAuthentication (MFA) to add an extra layer of security. 
    2.    Minimal Privilege Principle: Assign the least privilege necessary to your AWS roles and permissions. This
limitspotential damage if an account is compromised. 
    3.    Security Groups and Network ACLs: Configure these to control inbound and outbound traffic to your instances
strictly.This helps prevent unauthorized access. 
    4.    Regular Monitoring and Audits: Use AWS CloudTrail and other monitoring tools to keep track of activities and
detectunusual access patterns or potential security threats. 
    5.    Data Encryption: Use AWS’s built-in tools to encrypt your data at rest and in transit. This ensures that your
datais secure, even if intercepted. 

Regarding your interest in installation exercises, while AWS does offer pre-built options, you can also configure
customPostgreSQL installations on EC2 instances. This allows you to practice installation, configuration, and
managementas if you were handling a server in your own data center. 

I hope these tips help you feel more confident in using cloud environments securely. Wishing you the best in your
learningjourney! 

Best regards,
Sondra

Sent from my iPhone

> On May 15, 2024, at 11:22 PM, Edwin UY <edwin.uy@gmail.com> wrote:
>
> 
> Hi,
>
> I need to learn PostgreSQL and some other new skills, worried about finding a new job sort of.
> Budget wise, I don't have the means to do so, especially financially.
>
> Does anyone know of any site that is offering free resources to learn PostgreSQL, install, scripting, backup and
recovery.
> I had AWS Free Tier before but that was hacked so I was a bit worried about going back. Also, I will want to do some
installexercise, not sure if that is something that is possible with AWS as they are pre-build, isn't it? 
>
> I am sure performance tuning will take a lifetime to learn.
>
> Regards,
> Edwin
>



В списке pgsql-admin по дате отправления:

Предыдущее
От: ravi k
Дата:
Сообщение: Replication slot dropped in Bidirection rep: column addition
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Queries in replica are failing