将Heroku数据库URL称为"HEROKU_POSTGRESQL_WHITE_URL"有什么意义? [英] What's the significance when a Heroku database URL is called 'HEROKU_POSTGRESQL_WHITE_URL'?

问题描述

当数据库URL称为HEROKU_POSTGRESQL_WHITE_URL时，意义"(如果有)是什么?我在Heroku的文档中看到过其他名称，例如"HEROKU_POSTGRESQL_PURPLE_URL"，HEROKU_POSTGRESQL_CHARCOAL_URL，...

What's the "significance" - if any - when a database URL is called HEROKU_POSTGRESQL_WHITE_URL? I've seen other names in Heroku's documentation such as 'HEROKU_POSTGRESQL_PURPLE_URL', HEROKU_POSTGRESQL_CHARCOAL_URL,...

这是否意味着它始终是您的主数据库或要配置的第一个数据库?我会很高兴知道.

Does it mean it's always your primary database, or first database to be provision? I would love to know.

$ heroku pg:info
=== HEROKU_POSTGRESQL_WHITE_URL (DATABASE_URL)
Plan:               Standard 0
Status:             Available
Data Size:          491.9 MB
Tables:             22
PG Version:         9.3.5
....

推荐答案

颜色是随机选择的，并且在创建数据库的应用程序范围内唯一存在.在多种应用中，颜色没有任何意义或相关性.

Colors are picked randomly and exist uniquely in the scope of the application the database was created on. Across multiple applications, colors have no meaning or correlation.

通过示例，您可以有2个应用程序，其中4种不同的数据库仅使用3种颜色:

By example, you can have 2 applications with 4 distinct databases using only 3 colors:

• my_awesome_application
  • HEROKU_POSTGRESQL_WHITE_URL
  • HEROKU_POSTGRESQL_RED_URL
  • my_awesome_application
    • HEROKU_POSTGRESQL_WHITE_URL
    • HEROKU_POSTGRESQL_RED_URL
    • HEROKU_POSTGRESQL_BLUE_URL
    • HEROKU_POSTGRESQL_WHITE_URL

    db:info中标记为(DATABASE_URL)的颜色是您的应用程序正在连接的颜色(除非您进行了其他配置).如果您查看heroku config，将会看到类似

    The color in db:info marked (DATABASE_URL) is the one your application is connecting to (unless you've configured something else). If you look at heroku config, you'll see something like

    HEROKU_POSTGRESQL_WHITE_URL=postgres://path.to:a/db
    DATABASE_URL=<the same value WHITE has>
    

    如果您已在同一个应用程序上配置了其他数据库(例如关注者)，则会在config中看到具有不同URL的更多颜色.如果他们是关注者，pg:info会告诉您他们正在关注哪个数据库.

    If you've provisioned other databases on the same app, like followers, you'll see more colors in config with different URLs. If they're followers, pg:info tells you which DB they're following.

    这篇关于将Heroku数据库URL称为"HEROKU_POSTGRESQL_WHITE_URL"有什么意义?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！