This repository has been archived by the owner. It is now read-only.

Amazon RDS PostgreSQL

Benjamin Oakes edited this page Nov 15, 2013 · 1 revision
  • Automated backups snapshot every 5 minutes, can restore to basically any time. Max retention 35 days
  • Micro is on the free usage tier
  • scales 5gb - 3tb
  • multi AZ, primary automatically fails over to secondary -- transparently

postgresql.conf

  • db parameter groups, can configure via formulas (based on available memory, etc)

  • sets config file if "static" apply type

  • version 9.3.1

  • wizard for creating (or CLI)

Permissions

  • superuser role + rds_superuser role

Extensions

  • rds.extensions parameter (lists all available extensions -- not just PostGIS)

Moody's

  • Good experience
  • If you're already using PostgreSQL, easy to switch
  • Lots of stuff becomes easy (read replicas, backups, etc)

Questions

  • pgdump
  • logs available via API, including slow query
  • moving legacy data (Moody's guy said flat files)

A crowd-sourced conference wiki!
Working together is better. :)




Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.