Create a PostgreSQL Server Using AWS EC2
  • Introduction
  • AWS EC2: Launching Instance
    • Overview
    • Create Security Group
    • Create Launch Template
    • Option 1: Create Auto Scaling Group
    • Option 2: Create a Single Instance
    • Attach Elastic IP Address
  • Ubuntu 20.04: Configuring PostgreSQL
    • Overview
    • Install PostgreSQL
    • Add Role to PostgreSQL Server
    • Allow Remote Connection
  • Remote Server: Accessing Server on Local Computer
    • Overview
    • Connect with pgAdmin4
    • Connect with Python API
  • AWS EC2: Backup Server
    • Overview
    • Configuring Automatic Backups
  • Next Steps
Powered by GitBook
On this page

Was this helpful?

Next Steps

Things to do after setting up PostgreSQL server

You now have a brand new PostgreSQL server! Some things to do next would be to...

(1) create users to access the server and databases,

(2) create tables and insert data into your databases, either using Python's API or pgadmin4 interface,

(3) increase your server's security by specifying which IP addresses have access to the server,

... and much more!

As I said in the introduction, feel free to reach out to me with any questions or concerns about the documentation!

Email: belicia.taylor@gmail.com

Twitter: @beliciataylor

PreviousConfiguring Automatic Backups

Last updated 4 years ago

Was this helpful?