Amazon RDS supports DB instances running several versions of PostgreSQL. Currently we supportPostgreSQL versions 9.3.1, 9.3.2, and 9.3.3. You can create DB instances and DB snapshots, point-intimerestores and backups.
DB instances running PostgreSQL support Multi-AZ deployments, Provisioned IOPS, and can becreated inside a VPC. You can also use SSL to connect to a DB instance running PostgreSQL. You canuse any standard SQL client application to run commands for the instance from your client computer.Such applications include pgAdmin, a popular Open Source administration and development tool forPostgreSQL, or psql, a command line utility that is part of a PostgreSQL installation. In order todeliver a managed service experience, Amazon RDS does not provide host access to DB instances,and it restricts access to certain system procedures and tables that require advanced privileges.
Amazon RDS supports access to databases on a DB instance using any standard SQL clientapplication. Amazon RDS does not allow direct host access to a DB instance via Telnet or Secure Shell(SSH).
Reference:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html