无法访问 postgres 文件 pg

问：

当我运行db：create时出现此错误：

FATAL:  Peer authentication failed for user "wandrr"
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1208:in `initialize'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1208:in `new'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:1208:in `connect'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:326:in `initialize'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:28:in `new'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:28:in `postgresql_connection'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:315:in `new_connection'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:325:in `checkout_new_connection'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:247:in `block (2 levels) in checkout'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:242:in `loop'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:242:in `block in checkout'
/home/jack/.rvm/rubies/ruby-1.9.3-p327/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:239:in `checkout'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:102:in `block in connection'
/home/jack/.rvm/rubies/ruby-1.9.3-p327/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:101:in `connection'
/home/jack/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:410:in `retrieve_connection'
....Edit out 40 more of these warnings...
/home/jack/.rvm/gems/ruby-1.9.3-p327/bin/ruby_noexec_wrapper:14:in `eval'
/home/jack/.rvm/gems/ruby-1.9.3-p327/bin/ruby_noexec_wrapper:14:in `<main>'
Couldn't create database for {"adapter"=>"postgresql", "encoding"=>"unicode", "database"=>"wandrr_test", "pool"=>5, "username"=>"wandrr", "password"=>nil}

我发现我必须编辑 pg_hba.conf。问题是它打不开。它一直告诉我我没有使用这个文件的权限。那么我如何获得许可呢？我正在运行 ubuntu 12.10、rails 1.9.3 和 postgres 9.1。

PostgreSQL Ubuntu

@JackJenkins 如果您没有指定路径，并且当前目录不是的位置，那么将尝试在当前目录（可能是您的主文件夹）中打开它，但没有找到它，并开始编辑保存时创建的新文件。您需要指定完整路径，例如从 Ubuntu 软件包安装的 Pg。要获取路径，请使用 .pg_hba.confsudo vi pg_hba.confpg_hba.confsudo vi /etc/postgresql/9.1/main/pg_hba.confSHOW hba_file;psql

答：

31赞 Craig Ringer 12/2/2012 #1

首先记下系统上的位置。如果您不知道，但可以连接，请使用 PgAdmin-III 连接到 Pg 或运行：pg_hba.confpsql

SHOW hba_file;

获取的位置。它的位置相当标准;在 Ubuntu 上，它将在例如.在大多数其他发行版上，它将直接或在版本化目录中位于或下。pg_hba.conf/etc/postgresql/[major.minor]/main/pg_hba.conf/etc/postgresql/9.1/main/pg_hba.conf/var/lib/pgsql//var/lib/postgresql

若要编辑此文件，必须先指定完整路径或将目录更改为其位置。说：

sudo vi /etc/postgresql/9.1/main/pg_hba.conf

如果您更喜欢更友好的文本编辑器：

sudo nano /etc/postgresql/9.1/main/pg_hba.conf

或者将“nano”替换为您喜欢的编辑器，例如 .gedit

保存更改后，请记住重新加载 PostgreSQL 服务以使其生效。在 Ubuntu 上，您需要：

pg_ctlcluster 9.1 main reload

无法访问 postgres 文件 pg_hba.conf

can't access postgres file pg_hba.conf

评论

评论