Get started

    Create and Connect to Render Postgres

    Migrating a large database from Heroku?

    The Render team can help you orchestrate your migration to minimize downtime, even for apps with multi-terabyte databases.

    Contact the Render team

    Render Postgres databases provide fully managed, scalable storage of relational data.

    All paid Render Postgres databases provide point-in-time recovery and on-demand logical exports. Larger instances support read replicas and high availability for improved performance and reliability.

    Quickstarts

    Here are a few Render quickstarts that include a Render Postgres database as part of their application stack:

    Create your database

    1. Go to dashboard.render.com/new/database, or click + New > Postgres in the Render Dashboard.

      This form appears:

      New Postgres creation form

    2. Provide a helpful Name for your database.

      • You can change this value at any time.

    3. Optionally fill in the Database and/or User fields if you want to set your PostgreSQL dbname and/or username.

      • Render generates values for either of these that you don't specify.
      • You can't change these values after creating your database.

    4. Choose a to run your database in.

      • Choose the same region as your services that will connect to the database. This minimizes latency and enables communication over your .

    5. Optionally change the PostgreSQL Version if you want to use an older version.

      • Major versions 13 through 18 are available for all new instances.
      • Versions 11 and 12 are available for workspaces that have at least one existing database on the corresponding version.

    6. Scroll down and select a compute plan for your database. This determines its available CPU and RAM.

      Learn about limitations of the Free compute plan.

      Selecting a Postgres compute plan

      You can change your compute plan later.

    7. Scroll down and set your database's initial storage, in GB.

      • You can specify 1 GB or any multiple of 5 GB.
      • You can increase your storage later, but you can't decrease it.

    8. Optionally enable Storage Autoscaling.

      • Whenever your database is 90% full, Render automatically increases its storage by 50%, rounded up to the nearest multiple of 5 GB. You can't reduce storage after increasing it. Learn more.

    9. Click Create Database.

    You're all set! Your new database's status updates to Available in the Render Dashboard when it's ready to use.

    1. Install the CLI

    Use any of the following methods to install the Render CLI or upgrade to the latest version:

    Homebrew installation

    Run the following commands:

    WinGet installation

    Run the following command:

    Installing with curl

    Run the following command:

    Direct download
    1. Open the CLI's GitHub releases page.
    2. Download the executable that corresponds to your system's architecture.

    If you use an architecture besides those provided, you can build from source instead.

    Building from source

    We recommend building from source only if no other installation method works for your system.

    1. Install the Go programming language if you haven't already.

    2. Clone and build the CLI project with the following commands:

    After installation completes, open a new terminal tab and run render with no arguments to confirm.

    2. Create your database

    Run render pg create to walk through an interactive wizard:

    To skip the wizard, provide flags directly. For example:

    Supply the following options to configure your database: