PostgreSQL的颜色有什么区别？ [英] What is the difference between colors of PostgreSQL?

问题描述

我正在尝试根据 https://devcenter.heroku.com/articles/heroku-postgresql#local-setup 。

当我grep '用于不同的heroku配置

 （heroku config | grep HEROKU_POSTGRESQL）
  pre> 
 
 
我收到以下回复：
 
 
  HEROKU_POSTGRESQL_AQUA_URL：postgres： //mzqgqmkhlsgufo:[e-mail]:5432/d8jndm2sub3lbt 
 HEROKU_POSTGRESQL_VIOLET_URL：postgres：// nviwubpznhhgkv：siEYPLdOknBWOj1K3HePMn21DS @ ec2-54- 243-188-54.compute-1.amazonaws.com:5482/ddr1fm1ou7ha9s 
  
做不同的颜色有什么意义？我会更好地使用一个在另一个或他们只是随机的颜色？对不起，如果这是一个愚蠢的问题，但我不会找到一个问题来解决这个问题。
解决方案
非常多，我认为 you 的主要区别在于他们听的端口。 Aqua在PostgreSQL默认端口5432上侦听;紫罗兰在5482.他们似乎有不同的IP地址，这可能会或可能不会影响你。 （我不记得应用程序连接到Heroku的顶部。）
 
 
 
如果您在本地安装，并且以前从未安装过PostgreSQL，它可能会侦听默认端口5432. 
 
 
 
颜色名称对PostgreSQL没有任何意义。这似乎是Heroku在管理他们的服务时使用的命名约定。
 
I am trying to set up a local version of PostgreSQL for use with my Rails app on Heroku according to the instructions at https://devcenter.heroku.com/articles/heroku-postgresql#local-setup.

When I grep'd for different heroku configurations 
(heroku config | grep HEROKU_POSTGRESQL)
I got the following return: 
HEROKU_POSTGRESQL_AQUA_URL:   postgres://mzqgqmkhlsgufo:[e-mail]:5432/d8jndm2sub3lbt
HEROKU_POSTGRESQL_VIOLET_URL: postgres://nviwubpznhhgkv:[e-mail]:5482/ddr1fm1ou7ha9s
Do the different colors have any significance? Would I be better served using one over the other or are they just random colors? Sorry if this is a silly question, but I wasn't about to find a question addressing this.
解决方案
Without digging into it very much, I think the main difference for you would be the port they listen on. Aqua listens on the PostgreSQL default port of 5432; violet on 5482. They seem to have different IP addresses, too, which might or might not affect you. (I don't recall off the top of my head how apps connect to Heroku.)

If you're installing locally, and you've never installed PostgreSQL before, it will probably listen on the default port, 5432. 

The color names don't mean anything to PostgreSQL. That just seems to be a naming convention Heroku uses in managing their services.

                        
这篇关于PostgreSQL的颜色有什么区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！