Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Step 2: Configuring & Launching the Postgres-RDS Database

Important!
Please note that our Postgres destination is currently in open beta. The information in this article is subject to change.

There are two steps to configuring the database: specifying the basic details and configuring more advanced settings.

Specifying the Database Details

In the Specify DB Details page, you’ll define the basic settings for your Postgres-RDS database. There are two sections on this page:

Instance Specifications

In the Instance Specifications section, you can select the licensing model, version, and more.

Setting What it means What you should do
License Model This is the license used by the database engine. Leave as-is - Postgres only has one license.
DB Engine Version This is the version of PostgreSQL the database will run on. Select your version, but keep in mind that Stitch only supports versions 9.3+.
DB Instance Class This indicates the Instance Class your database will run on. Select the Instance Class you want your database to run on.

If you’re not sure what this means or how to select the best option, check out Amazon’s documentation.
Multi-AZ Deployment This indicates whether your instance will use Multi-AZ Deployment. This is only available if you selected Production in the last section. This will default to Yes. Leave this setting as-is if you want Amazon to maintain a synchronous standby replica in a different Availability Zone. Amazon recommends this for Production Instances.
Storage Type This indicates the type of storage your database will use. This is only available if you selected Production in the last section. Select the type of storage you want your database to use.

If you’re not sure what this means or how to select the best option, check out Amazon’s documentation.
Allocated Storage This is the amount of storage for your database. Enter the amount of storage (in GB) you want for your database. If you need help deciding the amount, check out Amazon’s documentation.

Settings

In the Settings section, you’ll define the name of the database and the master user credentials.

  • DB Instance Identifier: Enter a name for the database instance. This name must be unique for your account in the Region you selected.
  • Master Username: Enter a username for the master user. For info on what permissions this user is granted, click here.
  • Master Password: Enter a password for the master user.
  • Confirm Password: Enter the master user’s password again to confirm.

When finished, click the Next Step button.

Configuring the Advanced Settings

In the Configuring Advanced Settings page, you’ll define the last group of settings the instance needs to run. There are several sections on this page:

Network & Security 

In this section, you'll define the network security settings for the database.

Setting What it means What you should do
VPC This setting refers to the Virtual Private Cloud, or the group of servers hosting the instance. If you’re a new AWS customer or don’t want to set up a VPC, you can use the Default option.

Otherwise, select the VPC you want the instance to reside in. Steps for how to create your own VPC are outside the scope of this tutorial, but Amazon has instructions here.
Subnet Group This setting refers to the subnets that the instance can use in the selected VPC. If you’re a new AWS customer or you’re not sure what this means, select the Default option.

You can refer to Amazon’s documentation for more info on subnets and VPCs.
Publicly Accessible This setting determines whether your instance has a publicly accessible IP address, which means it can be accessed from outside the selected VPC. Set this to Yes. This is required to connect the instance to Stitch.
Availability Zone This setting defines what availability zone you want the instance to reside in. If you have a preference, select it.

Otherwise, leave this as No Preference.
Security Groups This setting defines the in- and outbound traffic that can access the instance. If you have a Security Group you’d like to use, select it from the list.

If you’re a new AWS customer, you can use the Default option or Create new Security Group.

If you opt to create a new group, don’t worry too much about the settings for it - you’ll configure them in the next section of this tutorial.

Database Options

In this section, you'll define the database's name and parameter settings.

Setting What it means What you should do
Database Name This is the name of the initial database in the instance. This is the name you’ll enter into Stitch at the end of this tutorial to complete the connection setup. Enter a name for the database.
Database Port This is the port that the database will listen on. Use the default (5432) or enter a port.
DB Parameter Group This is the parameter group for the database. If you’ve created your own parameter group, select it here.

Otherwise use the Default group.
Option Group This is the option group for the database. If you’ve created your own option group, select it here.

Otherwise use the Default group.
Snapshots This will copy any database instance tags to a database snapshot when you create a snapshot. You can learn more about tagging here. This is your preference; it isn’t required by Stitch.
Encryption This determines if your data will be encrypted with AES-256 encryption in both the instances themselves and at rest. There are additional steps to setting this up, which you can find help for here. This is your preference; it isn’t required by Stitch.

Backup

In this section, you'll define the backup settings for the database.

Setting What it means What you should do
Backup Retention Period This defines the number of days you want automatic backups of your database to be retained. This is your preference; it isn’t required by Stitch.
Backup Window This defines the time your database is backed up. Unless you have a preference, use the default of No Preference.

This isn’t required by Stitch.

Maintenance

In this section, you'll define the maintenance settings for the database.

Setting What it means What you should do
Auto Minor Version Upgrade This defines whether your database instance will automatically receive minor database engine upgrades when they’re available. This is your preference; it isn’t required by Stitch.
Maintenance Window This defines the 30 minute window in which pending changes to your database instance are applied. Unless you have a preference, use the default of No Preference.

This is your preference; it isn’t required by Stitch.

When you’re finished, click Launch DB Instance to create and launch the instance.

Note that it may take a few minutes for the instance. The status in the RDS Dashboard page will change to Available when the process completes:



Next Steps

In the next step, you'll configure the firewall settings for the Postgres-RDS database.

Next: Configuring the Postgres-RDS Firewall Settings

Previous: Defining the Initial Settings for the Postgres-RDS Database

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!