pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: S Hoffman <hoffman7043@gmail.com>
To: Edwin UY <edwin.uy@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Where to learn PostgreSQL for free?
Date: Thu, 16 May 2024 07:17:04 -0700
Message-ID: <E70F2E8F-B1BE-4C29-A559-B67462912A65@gmail.com> (raw)
In-Reply-To: <CA+wokJ-rwfhB-JkKMPKx+j7kNXNM1ggP8R5YEfg3QgM1BdJ76w@mail.gmail.com>
References: <CA+wokJ-rwfhB-JkKMPKx+j7kNXNM1ggP8R5YEfg3QgM1BdJ76w@mail.gmail.com>

Good morning, Edwin,

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

	1.	Strong Access Controls: Always use strong, unique passwords for your AWS account and databases. Implement Multi-Factor Authentication (MFA) to add an extra layer of security.
	2.	Minimal Privilege Principle: Assign the least privilege necessary to your AWS roles and permissions. This limits potential 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 detect unusual 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 data is secure, even if intercepted.

Regarding your interest in installation exercises, while AWS does offer pre-built options, you can also configure custom PostgreSQL installations on EC2 instances. This allows you to practice installation, configuration, and management as 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 learning journey!

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 install exercise, 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
> 





view thread (7+ messages)

Message-ID: <E70F2E8F-B1BE-4C29-A559-B67462912A65@gmail.com>
Permalink:  ../E70F2E8F-B1BE-4C29-A559-B67462912A65@gmail.com/
Also on:    postgresql.org/message-id/E70F2E8F-B1BE-4C29-A559-B67462912A65@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: hoffman7043@gmail.com, edwin.uy@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Where to learn PostgreSQL for free?
  In-Reply-To: <E70F2E8F-B1BE-4C29-A559-B67462912A65@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox