{"version":1,"pages":[{"id":"-MK1ivJrotZeFUzadrbW","title":"Introduction","pathname":"/","siteSpaceId":"sitesp_RkfxL","description":"Introduction to using AWS EC2 to host PostgreSQL server"},{"id":"-MKIOK1i4FMxnn0NYTQM","title":"Overview","pathname":"/launching-instance/overview","siteSpaceId":"sitesp_RkfxL","description":"Configuring AWS EC2 auto scaling group for PostgreSQL","breadcrumbs":[{"label":"AWS EC2: Launching Instance"}]},{"id":"-MKLNdEjCJO8jKqTmk6i","title":"Create Security Group","pathname":"/launching-instance/aws-security-group","siteSpaceId":"sitesp_RkfxL","description":"Configure security group for launch template","breadcrumbs":[{"label":"AWS EC2: Launching Instance"}]},{"id":"-MKIK2sWYLGXVMaYQOeE","title":"Create Launch Template","pathname":"/launching-instance/launch-template","siteSpaceId":"sitesp_RkfxL","description":"Configurations for launch template","breadcrumbs":[{"label":"AWS EC2: Launching Instance"}]},{"id":"-MKIKIOW5qxulh_aNm-J","title":"Option 1: Create Auto Scaling Group","pathname":"/launching-instance/auto-scaling","siteSpaceId":"sitesp_RkfxL","description":"Configurations for auto scaling group","breadcrumbs":[{"label":"AWS EC2: Launching Instance"}]},{"id":"-MRFw4vyOJiHX_R61gVN","title":"Option 2: Create a Single Instance","pathname":"/launching-instance/create-instance","siteSpaceId":"sitesp_RkfxL","description":"Create a single instance from your launch template","breadcrumbs":[{"label":"AWS EC2: Launching Instance"}]},{"id":"-MKIKThkmS_KJSDXQe85","title":"Attach Elastic IP Address","pathname":"/launching-instance/elastic-ip-address","siteSpaceId":"sitesp_RkfxL","description":"Attach an elastic IP address to your PostgreSQL server instance","breadcrumbs":[{"label":"AWS EC2: Launching Instance"}]},{"id":"-MKILTKEhir7Jd2VORaN","title":"Overview","pathname":"/ubuntu-configuring-instance/overview","siteSpaceId":"sitesp_RkfxL","description":"Install and configure PostgreSQL on our Ubuntu instance","breadcrumbs":[{"label":"Ubuntu 20.04: Configuring PostgreSQL"}]},{"id":"-MKITnvVjiSL31MRcE6G","title":"Install PostgreSQL","pathname":"/ubuntu-configuring-instance/install-postgresql","siteSpaceId":"sitesp_RkfxL","description":"Install PostgreSQL onto your Ubuntu instance","breadcrumbs":[{"label":"Ubuntu 20.04: Configuring PostgreSQL"}]},{"id":"-MKIV0cEJl9Q601JBH6Z","title":"Add Role to PostgreSQL Server","pathname":"/ubuntu-configuring-instance/add-postgresql-roles","siteSpaceId":"sitesp_RkfxL","description":"Add role to login and create databases in your postgres server","breadcrumbs":[{"label":"Ubuntu 20.04: Configuring PostgreSQL"}]},{"id":"-MKSJ8jEWfd_0gi5Hlqk","title":"Allow Remote Connection","pathname":"/ubuntu-configuring-instance/remote-connection","siteSpaceId":"sitesp_RkfxL","description":"Configure client authentication and listen address for remote connection to PostgreSQL server","breadcrumbs":[{"label":"Ubuntu 20.04: Configuring PostgreSQL"}]},{"id":"-MKIMCxjNy3y4Qe-gISx","title":"Overview","pathname":"/remote-server-accessing-server-on-local-computer/remote-overview","siteSpaceId":"sitesp_RkfxL","description":"Remotely connect to your PostgreSQL server using pgAdmin4","breadcrumbs":[{"label":"Remote Server: Accessing Server on Local Computer"}]},{"id":"-MQx3X5UkjiOM1NA4lp9","title":"Connect with pgAdmin4","pathname":"/remote-server-accessing-server-on-local-computer/connect-with-pgadmin4","siteSpaceId":"sitesp_RkfxL","description":"Connecting to your PostgreSQL server hosted on AWS on your local pgAdmin4","breadcrumbs":[{"label":"Remote Server: Accessing Server on Local Computer"}]},{"id":"-MR5bVeSnq_WUM2TyQN5","title":"Connect with Python API","pathname":"/remote-server-accessing-server-on-local-computer/connect-with-python-api","siteSpaceId":"sitesp_RkfxL","description":"Connect to your server using python scripts","breadcrumbs":[{"label":"Remote Server: Accessing Server on Local Computer"}]},{"id":"-MQxbdQmCPZlu9f-YNM5","title":"Overview","pathname":"/backup-server/automatic-backups","siteSpaceId":"sitesp_RkfxL","description":"Backup the server to ensure your server and data will not be lost in the event of an instance failure","breadcrumbs":[{"label":"AWS EC2: Backup Server"}]},{"id":"-MR63rKCHkZfNDWOkmdP","title":"Configuring Automatic Backups","pathname":"/backup-server/automatic-backups-1","siteSpaceId":"sitesp_RkfxL","description":"Set up backups every","breadcrumbs":[{"label":"AWS EC2: Backup Server"}]},{"id":"-MRCVE4wrrbsNK83mUwW","title":"Next Steps","pathname":"/next-steps","siteSpaceId":"sitesp_RkfxL","description":"Things to do after setting up PostgreSQL server"}]}