Skip to content

Instantly share code, notes, and snippets.

@brijesh-deb

brijesh-deb/AWS_RDS_PostGres.md Secret

Last active January 12, 2018 10:49
Show Gist options
  • Save brijesh-deb/5e6cba3529f1ffcb726dbf853c1758db to your computer and use it in GitHub Desktop.
Save brijesh-deb/5e6cba3529f1ffcb726dbf853c1758db to your computer and use it in GitHub Desktop.
Download ZIP
#AWS #RDS
Raw
AWS_RDS_PostGres.md

Create RDS Postges instance & database

  • Services > RDS > Get Started Now
  • Select Engine : PostgreSQL
  • Specify DB details
    • License model
    • DB engine version
    • DB instance class [should be powerful enough to support planned workload]
    • Multi-AZ deployment: not needed for dev
    • Allocated storage
  • Settings
    • DB instance identifier: [db instance name]
    • Master username: [user name]
    • Master password: [password]
  • Configure advanced settings
    • VPC: select a VPC
    • Public accessibility: Yes (for dev)
    • Availability zone
    • VPC security group
  • click "Launch DB Instance"
  • Edit security group
    • Inbound > PostgreSQL > Source should be Anywhere

Connect to database using pgAdmin

  • Use following server properties
    • Name:[name]
    • Host:[AWS DB instance endpoint]
    • Port: 5432
    • Maintenance DB: postgres
    • Username:[user name provided during DB instance creation]
    • Password:[password provided during DB instance creation]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment