blocks|key|325960|text|这意味着你没有安装新的‘pg’postgresql库。这可以通过以下几点轻松解决：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|325961|sudo+gem+install+pg|code-block|syntax|javascript|325962|我(Dov)在网上找到了其他的解决方案，它们描述了设置GEM_HOME并将~/..gem/ruby/vers/bin添加到你的路径中，但它们都不起作用。上面的解决方案是由Mark+Mansour在他的博客State+of+Flux上提供的：http://stateofflux.com/2008/7/13/activerecord-postgresql-adapter-in-rails-2-1/|offset|length|325963|entityMap|0|LINK|mutability|MUTABLE|url|http://stateofflux.com/2008/7/13/activerecord-postgresql-adapter-in-rails-2-1/^0|0|0|3C|26|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

This means you don’t have the new ‘pg’ postgresql library installed. This is easily fixed with a bit of:

<pre><code>sudo gem install pg
</code></pre>

I (Dov) found other solutions on the web which described setting GEM_HOME and adding ~/.gem/ruby/vers/bin to your PATH, but they didn't work. This solution above was provided by
Mark Mansour on his blog State of Flux at:
<a href="http://stateofflux.com/2008/7/13/activerecord-postgresql-adapter-in-rails-2-1/" rel="nofollow noreferrer">http://stateofflux.com/2008/7/13/activerecord-postgresql-adapter-in-rails-2-1/</a>

blocks|key|329239|text|我在railsonpostgresql.com上对Ruby+%2B+PostgreSQL数据库驱动程序的现状做了一些总结；我认为sudo+gem+install+pg可能就是你想要的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|329240|entityMap|0|LINK|mutability|MUTABLE|url|http://railsonpostgresql.com/2009/09/04/rails-postgresql-and-database-drivers^0|1Q|J|2|L|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

I did a little roundup of the current state of Ruby + PostgreSQL database drivers on <a href="http://railsonpostgresql.com/2009/09/04/rails-postgresql-and-database-drivers" rel="nofollow noreferrer">railsonpostgresql.com</a>; I think <code>sudo gem install pg</code> is probably the one you want.

blocks|key|3294301|text|问题不在于任何人写的东西。问题是postgresql数据库适配器的名称是"postgresql"，而不是"postgres"，尽管GEM的名称是"pg“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3294302|database.yml文件中的定义应包括|3294303|++adapter:+postgresql|code-block|syntax|javascript|3294304|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

The problem is not what anyone wrote.
The problem is that the name of the postgresql database adapter is "postgresql", not "postgres", though the name of the GEM is "pg".

The definition in the database.yml file should include

<pre><code> adapter: postgresql
</code></pre>

blocks|key|326910|text|sudo+apt-get+install+ruby1.8-dev|type|unstyled|depth|inlineStyleRanges|entityRanges|data|326911|然后..。|326912|gem安装程序|326913|对我很管用！|326914|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

sudo apt-get install ruby1.8-dev

then...

gem install pg

Worked for me!

blocks|key|326013|text|你可以试试这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|326014|在debian上(挤压)：|326015|aptitude+install+libdbd-pg-ruby|code-block|syntax|javascript|326016|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can try this

On debian(squeeze):

<pre><code>aptitude install libdbd-pg-ruby
</code></pre>

blocks|key|326027|text|这是我从Heroku得到的答案，它对我很有效(在尝试了不同的pg+gem，适配器和其他10个关于这个问题的帖子之后)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|326028|1)将行:+gem+'pg‘添加到Gemfile中。|326029|2)运行bundle+install命令，将gem安装到您的bundle中。|326030|3)存放Gemfile和Gemfile.lock更改:+git+add+Gemfile+Gemfile.lock|326031|4)提交修改:+git+Commit+-m+"Install+the+pg+gem“|326032|5)重新部署到heroku:+git推送heroku+master|326033|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

Here's the answer I got from Heroku and it worked for me (after trying different pg gems, adapters, and everything else on the 10 other posts about this)

1) add the line: gem 'pg' to your Gemfile.

2) Run the command bundle install to install the gem into your bundle.

3) Stage the Gemfile and Gemfile.lock changes: git add Gemfile Gemfile.lock

4) Commit the changes: git commit -m "Install the pg gem"

5) Redeploy to heroku: git push heroku master

blocks|key|324387|text|检查database.yml环境数据库是否正确。如果是postgresql，您可能需要将其更改为引用mysql2或您在给定环境中使用的任何数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|324388|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Check database.yml environment db is correct. If it is postgresql, you might need to change it to refer to mysql2 or whatever db your using for your given environment.

blocks|key|326069|text|在尝试不同的搜索结果时，我安装了一堆。最终让我的环境停止抱怨的消息是：“请安装postgresql适配器:+gem+install+activerecord-postgresql-adapter”：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|326070|我删除了与适配器相关的所有gem，例如:+sudo+gem+uninstall+activerecord-jdbc-|326071|；sudo+gem+uninstall+activerecord-jdbcpostgresql-；sudo+gem+uninstall+activerecord-postgresql-|unordered-list-item|326072|；sudo+gem+uninstall+|326073|还删除了对适配器的引用，如下所示:gem+'activerecord-jdbcpostgresql-adapter'|326074|Leave++pg+(0.15.1)+|326075|(要检查pg的存在，请执行"gem+list")|326076|326077|326078|326079|然后运行"rake+db:create“就可以了。所以，我猜pg是最新的，并且工作正常。但是，当周围有其他损坏的适配器gems时，它不会被使用。|326080|entityMap^0|0|0|0|0|0|1|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|X|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|11|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|15|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|U|$]]

While trying out different search results, I installed a bunch. What finally got my environment to stop complaining with this message: "Please install the postgresql adapter: gem install activerecord-postgresql-adapter" was:

<ul>
<li>I removed all gems relating to the adapter such as:
sudo gem uninstall activerecord-jdbc-adapter;
sudo gem uninstall activerecord-jdbcpostgresql-adapter;
sudo gem uninstall activerecord-postgresql-adapter;
sudo gem uninstall jdbc-postgres;</li>
<li>I also removed references to adapter as followed inside my Gemfile:
gem 'activerecord-jdbcpostgresql-adapter'</li>
<li>Leave only pg (0.15.1) installed (to check for existence of pg, do "gem list")</li>
</ul>

Then running "rake db:create" works. So, I guess pg is the latest and works. However, it does not get used when other broken adapter gems are around.

blocks|key|3294502|text|还有一个更深层次的隐藏条件也会导致这个错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3294503|如果你设置了一个本地环境变量DATABASE_URL=postgres://mehmehmeh，那么一些gem+(我怀疑Heroku)会导致应用程序认为Postgres是必需的，即使它不在你的配置中。删除环境变量就可以了。|offset|length|style|BOLD|3294504|entityMap^0|0|E|X|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

There is one more deeply hidden condition that will also cause this error.

If you have a local environment variable DATABASE_URL=postgres://mehmehmeh set, then some gem (I suspect Heroku) causes the app to think that Postgres is required even if it's nowhere in your configs. Kill that env variable and you should be fine.

Running a Ruby on Rails (RoR) app or Ruby code which uses the ActiveRecord framework, you get the error message:

<blockquote>
 Please install the postgresql adapter:
 <code>gem install
 activerecord-postgresql-adapter</code>
</blockquote>

Trying to run:

<pre><code>gem install activerecord-postgresql-adapter
</code></pre>

also fails, leaving you at a loss.

How to handle Ruby on Rails error: "Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'"

SQL数据库

PostgreSQL

数据库

运行Ruby on Rails (RoR)应用程序或使用ActiveRecord框架的Ruby代码时，您会得到错误消息：请安装postgresql适配器：gem install   activerecord-postgresql-adapter正在尝试运行：gem install activerecord-postgr...

问如何处理Ruby on Rails错误：“请安装postgresql适配器：` `gem install activerecord-postgresql-adapter'”
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何处理Ruby on Rails错误：“请安装postgresql适配器：` `gem install activerecord-postgresql-adapter'”EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何处理Ruby on Rails错误：“请安装postgresql适配器：` `gem install activerecord-postgresql-adapter'”
EN