Create a PostgreSQL DB Instance

In the top right corner of the AWS Management Console, select the AWS Region where
you want to create the DB
instance.

In the navigation pane, choose Instances.

If the navigation pane is closed, choose the menu icon at the top left to open it.

Choose Create database to start open on the Select engine page.

On the Select engine page, choose the PostgreSQL icon, and then choose
Next.

Next, the Use case page asks if you are planning to use the DB
instance you are creating for production. If you are, choose
Production. If you choose this option, the following
are preselected in a later step:

Multi-AZ failover option

Provisioned IOPS storage option

Enable deletion protection option

Choose Next when you are finished.

On the Specify DB Details page, specify your DB instance information.
Choose Next when you are finished.

For This Parameter

Do This

License Model

PostgreSQL has only one license model. Choose
postgresql-license to use
the general license agreement for PostgreSQL.

DB Engine Version

Choose the version of PostgreSQL you want to use.

DB Instance Class

Choose db.t2.small for a configuration that equates to 2 GiB
memory, 1 ECU (1 virtual core with 1 ECU), 64-bit
platform, and moderate I/O capacity. For more
information about all the DB instance class options, see
DB Instance Class.

Multi-AZ Deployment

Choose Yes to have a standby replica of your DB instance created in another Availability Zone
for failover support.
We recommend Multi-AZ for production workloads to maintain high availability.
For development and testing, you can choose No.

Choose the storage type General Purpose (SSD). For more
information about storage, see DB instance storage.

Allocated Storage

Type 20 to allocate 20 GiB of storage for your database. In some
cases, allocating a higher amount of storage for your DB
instance than the size of your database can improve I/O
performance. For more information about storage
allocation, see Amazon Relational Database Service Features.

DB Instance Identifier

Type a name for the DB instance that is unique for your account in the region you
chose. You can add some intelligence to the name,
such as including the region and DB engine you chose,
for example
postgreSQL-test.

This setting depends on the platform you are on. If you are a new customer to AWS,
choose the default VPC shown. If you are creating a DB
instance on the previous E2-Classic platform that does
not use a VPC, choose Not in VPC.
For more information about VPC, see Amazon Virtual Private Cloud (VPCs) and Amazon RDS.

Subnet Group

This setting depends on the platform you are on. If you are a new customer to AWS,
choose default, which is the
default DB subnet group that was created for your
account. If you are creating a DB instance on the
previous E2-Classic platform and you want your DB
instance in a specific VPC, choose the DB subnet group
you created for that VPC. For more information about
VPC, see Amazon Virtual Private Cloud (VPCs) and Amazon RDS.

Publicly Accessible

Choose Yes to give the DB instance a public IP address,
meaning that it is accessible outside the VPC;
otherwise, choose No, so the DB
instance is only accessible from inside the VPC.
For more information about hiding DB instances from
public access, see Hiding a DB Instance in a VPC from the Internet.

Availability Zone

Use the default value of No Preference unless you want to
specify an Availability Zone.

VPC Security Group

If you are a new customer to AWS, choose the default VPC. If you created a VPC security
group, choose the VPC security group you previously
created.

Database Name

Type a name for your database of up to 63 alpha-numeric characters. If you do not
provide a name, the default "postgres" database is
created.

Set the number of days you want automatic backups of your database to be retained.
For testing
purposes, you can set this value to
1.

Backup Window

Unless you have a specific time that you want to have your database backup, use the
default of
No Preference.

Enable Enhanced Monitoring

Choose Yes to enable real-time OS monitoring.
Amazon RDS provides metrics in real time for the operating system (OS)
that your DB instance runs on. You are only charged for Enhanced Monitoring
that exceeds the free tier provided by Amazon CloudWatch Logs.

Monitoring Role

Choose Default to use the
default IAM role.

Granularity

Choose 60 to monitor the
instance every minute.

Auto Minor Version Upgrade

Choose Yes to enable your DB instance to receive minor DB engine
version upgrades automatically when they become
available.

Maintenance Window

Choose the 30-minute window in which pending modifications to your DB instance are
applied. If
the time period doesn't matter, choose No
Preference.

Enable deletion protection

Enable deletion protection to prevent
your DB instance from being deleted. If you create a production
DB instance with the AWS Management Console, deletion protection is enabled
by default. For more information, see Deleting a DB Instance.

On the final page, choose Create database.

On the Amazon RDS console, the new DB instance appears in the list of DB instances.
The DB
instance will have a status of creating until the DB instance
is created and ready for use. When the state changes to
available, you can connect to the DB instance.
Depending on the DB instance class and store allocated, it could take several
minutes for the new instance to be available.

CLI

To create a PostgreSQL DB instance, use the AWS CLI create-db-instance command with the following parameters: