# Postgres connection problems

**URL:** <https://www.ruby-forum.com/t/postgres-connection-problems/65119>\
**Category:** Rails\
**Created:** [February 9, 2006, 8:44pm UTC](https://www.ruby-forum.com/t/postgres-connection-problems/65119 "2006-02-09T20:44:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sherman\_L](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/cdc98d/32.png) [@Sherman\_L](https://www.ruby-forum.com/u/Sherman_L)\
**Post date:** [February 9, 2006, 8:44pm UTC](https://www.ruby-forum.com/t/postgres-connection-problems/65119/1 "2006-02-09T20:44:57Z")

</div>

Hello, I’m a newbie to rails and I am trying to do the Demo in the  
November Issue of Linux Journal. Things go fine go fine until I try to  
connect to my Postgres database (ver 8.1). At this point I get the  
following error message

---- RoR error and trace back ----  
PGError in Admin#index

could not connect to server: Permission denied  
Is the server running on host “localhost” and accepting  
TCP/IP connections on port 5432?

RAILS\_ROOT: /var/www/html/blog/public/…/config/…  
Application Trace | Framework Trace | Full Trace

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in  
`connect' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in`postgresql\_connection’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:145:in  
`connection_without_query_cache=' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/query_cache.rb:54:in`connection=’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:106:in  
`retrieve_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:20:in`connection’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:518:in  
`count_by_sql' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:511:in`count’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:167:in  
`count_collection_for_pagination' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:188:in`paginator\_and\_collection\_for’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:124:in  
`paginate' #{RAILS_ROOT}/app/controllers/admin_controller.rb:8:in`list’  
#{RAILS\_ROOT}/app/controllers/admin\_controller.rb:3:in `index’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in  
`connect' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in`postgresql\_connection’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:145:in  
`connection_without_query_cache=' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/query_cache.rb:54:in`connection=’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:106:in  
`retrieve_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:20:in`connection’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:518:in  
`count_by_sql' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:511:in`count’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:167:in  
`count_collection_for_pagination' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:188:in`paginator\_and\_collection\_for’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:124:in  
`paginate' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:853:in`perform\_action\_without\_filters’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/filters.rb:332:in  
`perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/rescue.rb:82:in  
`perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in`process\_without\_session\_management\_support’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/session\_management.rb:116:in  
`process' /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in`dispatch’  
/var/www/html/blog/public/dispatch.cgi:10

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in  
`connect' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in`postgresql\_connection’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:145:in  
`connection_without_query_cache=' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/query_cache.rb:54:in`connection=’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:106:in  
`retrieve_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:20:in`connection’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:518:in  
`count_by_sql' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:511:in`count’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:167:in  
`count_collection_for_pagination' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/pagination.rb:188:in`paginator\_and\_collection\_for’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:124:in  
`paginate' #{RAILS_ROOT}/app/controllers/admin_controller.rb:8:in`list’  
#{RAILS\_ROOT}/app/controllers/admin\_controller.rb:3:in `index' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:853:in`perform\_action\_without\_filters’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/filters.rb:332:in  
`perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/rescue.rb:82:in  
`perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_controller/base.rb:369:in`process\_without\_session\_management\_support’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/session\_management.rb:116:in  
`process' /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in`dispatch’  
/var/www/html/blog/public/dispatch.cgi:10

Request

Parameters: None

Show session dump

flash: !map:ActionController::Flash::FlashHash {}

Response  
Headers: {“cookie”=\>[], “Cache-Control”=\>“no-cache”}  
— Error Traceback end----

So, it looks like I can’t get a TCP connection, right?

So i’s think wait I have a Zope installation that accesses this postgres  
installation using a tcp/ip connection, hmmmm.

So i’s thinks some more and decide that it must be a ruby problem. So I  
try this script

---- ruby sript ----  
require “postgres”  
conn= PGconn.connect(“localhost”, 5432, “”, “”,  
“blog\_development”,“blog”)  
print conn.user  
print conn.exec(“INSERT INTO Blogs (title, contents) VALUES (‘test’,  
‘Test contents’);”)  
---- ruby script end----

I go check the database and the new row is in the Blogs table.  
I thinks some more and play with my database.yml file (below) trying to  
get it to work, but no go. This should be real simple. Does any of u’s  
see what I have done wrong?

---- database.yml ----  
development:  
adapter: postgresql  
database: blog\_development  
host: localhost  
username: blog  
password:  
test:  
adapter: postgresql  
database: blog\_test  
host: localhost  
username: blog  
password:  
production:  
adapter: postgresql  
database: blog\_production  
host: localhost  
username: blog  
password:  
—database.yml end----

TIA,

## Sherman

Two wrongs don’t make a right, but… Two rights make a U-turn, and two  
U turns make a circle, and two circles mke a figure-eight, and two  
figure-eights make a butterfly. --Bullwinkle J. Moose

---

<div class="post-metadata">

**Author:** ![Sherman\_L](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/cdc98d/32.png) [@Sherman\_L](https://www.ruby-forum.com/u/Sherman_L)\
**Post date:** [February 9, 2006, 9:17pm UTC](https://www.ruby-forum.com/t/postgres-connection-problems/65119/2 "2006-02-09T21:17:35Z")

</div>

Hi,

I thinks this is the your postgresql configuration  
probleme, which version of postresql you are using?

you have to activate the “tcipip\_socket” variable  
inside the postgresql.conf if you are using V7, if you  
are using v8, you have to activate the “port”  
variable.

if those varaible is activated, verify you local  
firewall.

Hop it will help

Saiho

— Sherman L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> PGError in Admin#index
> 
> could not connect to server: Permission denied  
> Is the server running on host “localhost” and  
> accepting  
> TCP/IP connections on port 5432?
> 
> RAILS\_ROOT: /var/www/html/blog/public/…/config/…  
> Application Trace | Framework Trace | Full Trace

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in

> `connect’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in

> `postgresql\_connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:145:in

> `connection\_without\_query\_cache=’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/query\_cache.rb:54:in

> `connection=’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:106:in

> `retrieve\_connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:20:in

> `connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:518:in

> `count\_by\_sql’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:511:in

> `count’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:167:in

> `count\_collection\_for\_pagination’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:188:in

> `paginator\_and\_collection\_for’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:124:in

> `paginate’

#{RAILS\_ROOT}/app/controllers/admin\_controller.rb:8:in

> `list’

#{RAILS\_ROOT}/app/controllers/admin\_controller.rb:3:in

> `index’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in

> `connect’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in

> `postgresql\_connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:145:in

> `connection\_without\_query\_cache=’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/query\_cache.rb:54:in

> `connection=’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:106:in

> `retrieve\_connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:20:in

> `connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:518:in

> `count\_by\_sql’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:511:in

> `count’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:167:in

> `count\_collection\_for\_pagination’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:188:in

> `paginator\_and\_collection\_for’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:124:in

> `paginate’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:853:in

> `perform\_action\_without\_filters’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/filters.rb:332:in

> `perform\_action\_without\_benchmark’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:69:in

> `perform_action_without_rescue' /usr/lib/ruby/1.8/benchmark.rb:293:in `measure’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:69:in

> `perform\_action\_without\_rescue’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/rescue.rb:82:in

> `perform\_action’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:369:in

> `process\_without\_session\_management\_support’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/session\_management.rb:116:in

> `process’

/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in

> `dispatch’  
> /var/www/html/blog/public/dispatch.cgi:10

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in

> `connect’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/postgresql\_adapter.rb:23:in

> `postgresql\_connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:145:in

> `connection\_without\_query\_cache=’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/query\_cache.rb:54:in

> `connection=’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:106:in

> `retrieve\_connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:20:in

> `connection’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:518:in

> `count\_by\_sql’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active\_record/base.rb:511:in

> `count’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:167:in

> `count\_collection\_for\_pagination’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:188:in

> `paginator\_and\_collection\_for’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/pagination.rb:124:in

> `paginate’

#{RAILS\_ROOT}/app/controllers/admin\_controller.rb:8:in

> `list’

#{RAILS\_ROOT}/app/controllers/admin\_controller.rb:3:in

> `index’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:853:in

> `perform\_action\_without\_filters’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/filters.rb:332:in

> `perform\_action\_without\_benchmark’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:69:in

> `perform_action_without_rescue' /usr/lib/ruby/1.8/benchmark.rb:293:in `measure’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/benchmarking.rb:69:in

> `perform\_action\_without\_rescue’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/rescue.rb:82:in

> `perform\_action’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/base.rb:369:in

> `process\_without\_session\_management\_support’

/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action\_controller/session\_management.rb:116:in

> `process’

/usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/dispatcher.rb:38:in

> accesses this postgres  
> print conn.user  
> simple. Does any of u’s  
> adapter: postgresql  
> —database.yml end----  
> figure-eights make a butterfly. --Bullwinkle J.  
> Moose
> 
> * * *
> 
> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

* * *

Do You Yahoo!?  
Tired of spam? Yahoo! Mail has the best spam protection around

> **[\[object](https://mail.yahoo.com/)**
>
> \[object

---

<div class="post-metadata">

**Author:** ![Sherman\_L](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/cdc98d/32.png) [@Sherman\_L](https://www.ruby-forum.com/u/Sherman_L)\
**Post date:** [February 10, 2006, 3:01am UTC](https://www.ruby-forum.com/t/postgres-connection-problems/65119/3 "2006-02-10T03:01:26Z")

</div>

On Thu, 2006-02-09 at 12:44 -0700, Sherman L. wrote:

> Hello, I’m a newbie to rails and I am trying to do the Demo in the  
> November Issue of Linux Journal. Things go fine go fine until I try to  
> connect to my Postgres database (ver 8.1). At this point I get the  
> following error message

* * *

you probably need to configure pg\_hba.conf if you haven’t done that  
already.

That’s what it sounds like to me…

Also, if you haven’t done this already…

[sudo] gem install postgresql

Craig