How to Connect dbt to PostgreSQL on Amazon Linux 2 (Step-by-Step Guide)

 This is not a document that creates an account for aws, or builds ec2. Please refer to my other documents.

1. Environment Overview (Amazon Linux 2 + PostgreSQL + dbt)

2. How to Install dbt

3. Configuring PostgreSQL Connection (profiles.yml)

4. Testing the Connection

5. Common Errors and How to Fix Them

6. Conclusion

The target os is Amazon Linux 2.