# Rails e postgres

**URL:** <https://www.ruby-forum.com/t/rails-e-postgres/111814>\
**Category:** IT\
**Created:** [August 11, 2007, 1:24pm UTC](https://www.ruby-forum.com/t/rails-e-postgres/111814 "2007-08-11T13:24:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ranza](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/df705f/32.png) [@ranza](https://www.ruby-forum.com/u/ranza)\
**Post date:** [August 11, 2007, 1:24pm UTC](https://www.ruby-forum.com/t/rails-e-postgres/111814/1 "2007-08-11T13:24:42Z")

</div>

Salve a tutti,  
sono un nuovo utente, alle prime armi con ruby, con un problemino non  
che non riesco a risolvere.

Devo sviluppare una web application in ruby come progetto universitario  
che deve usare come specifica imprescindibile postgres.

Lavoro con Ubuntu 7.07 (fetsy), ho installato rubygem, ruby, rails,  
postgres-pr per l’interfacciamento al psql. Installato a parte  
postgresql-8.2, funzionante, mi connetto senza problemi con pgadminIII,  
ho creato il mio db tramite create table in sql. Ho modificato il file  
database.yml per postgresql… e fino a qui tutto ok!

Ma ora che devo creare i modelli con “script/generate model” ricevo  
questo errore

./script/…/config/…/vendor/rails/activerecord/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:204:in  
`establish_connection': development database is not configured (ActiveRecord::AdapterNotSpecified) from ./script/../config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:195:in`establish\_connection’  
from  
./script/…/config/…/vendor/rails/railties/lib/initializer.rb:229:in  
`initialize_database' from ./script/../config/../vendor/rails/railties/lib/initializer.rb:88:in`process’  
from  
./script/…/config/…/vendor/rails/railties/lib/initializer.rb:43:in  
`send' from ./script/../config/../vendor/rails/railties/lib/initializer.rb:43:in`run’  
from ./script/…/config/…/config/environment.rb:13  
from  
./script/…/config/…/vendor/rails/railties/lib/commands/generate.rb:1:in  
`require' from ./script/../config/../vendor/rails/railties/lib/commands/generate.rb:1 from script/generate:5:in`require’  
from script/generate:5

Qualcuno ha qualche idea??? Ho fatto qualche enorme errore concettuale?

Ciao e grazie  
Marco

---

<div class="post-metadata">

**Author:** ![ranza](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/df705f/32.png) [@ranza](https://www.ruby-forum.com/u/ranza)\
**Post date:** [August 11, 2007, 3:50pm UTC](https://www.ruby-forum.com/t/rails-e-postgres/111814/2 "2007-08-11T15:50:46Z")

</div>

Com’e il tuo file database.yml - puoi copiare il pezzo che descrive il  
db di sviluppo (cambiando, se vuoi, la password)?

–  
David N. Welton  
[http://www.welton.it/davidw/](http://www.welton.it/davidw/)

DedaSys LLC  
[http://www.dedasys.com](http://www.dedasys.com)

---

<div class="post-metadata">

**Author:** ![ranza](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/df705f/32.png) [@ranza](https://www.ruby-forum.com/u/ranza)\
**Post date:** [August 11, 2007, 4:41pm UTC](https://www.ruby-forum.com/t/rails-e-postgres/111814/3 "2007-08-11T16:41:09Z")

</div>

Non c’è nessun problema tanto lavoro in locale… questo è il file  
database.yml

development:  
adapter: postgres  
database: pizzeria  
username: mranzato  
password: choh4yae  
host: localhost

test:  
adapter: postgres  
database: pizzeria  
username: mranzato  
password: choh4yae  
host: localhost

production:  
adapter: postgres  
database: pizzeria  
username: root  
password:  
host: localhost

---

<div class="post-metadata">

**Author:** ![ranza](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/df705f/32.png) [@ranza](https://www.ruby-forum.com/u/ranza)\
**Post date:** [August 11, 2007, 5:25pm UTC](https://www.ruby-forum.com/t/rails-e-postgres/111814/4 "2007-08-11T17:25:22Z")

</div>

Avevi ragione!!!  
Avendo utilizzato gem postgres per installare l’adapter ho inserito lo  
stesso nome anche su database.yml.

Ho anche avuto qualche problema con l’installazione con gem di  
postgres-pr (pure rubi). Lo ho rimosso ed ho installato postgres,  
esportando il nome della libreria degli headers.  
Ora sembra andare…

Grazie David

---

<div class="post-metadata">

**Author:** ![ranza](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/df705f/32.png) [@ranza](https://www.ruby-forum.com/u/ranza)\
**Post date:** [August 11, 2007, 4:45pm UTC](https://www.ruby-forum.com/t/rails-e-postgres/111814/5 "2007-08-11T16:45:58Z")

</div>

On 8/11/07, Marco R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Non c’è nessun problema tanto lavoro in locale… questo è il file  
> database.yml
> 
> development:  
> adapter: postgres

Ho date un’occhiata, e ho notato subito che io uso l’adapter  
“postgresql”. Puo` essere questo il problema? C'e` un pacchetto  
ubuntu che si chiama libpgsql-ruby1.8. Non so cosa sia il  
‘postgres-pr’ che citi sopra.

–  
David N. Welton  
[http://www.welton.it/davidw/](http://www.welton.it/davidw/)

DedaSys LLC  
[http://www.dedasys.com](http://www.dedasys.com)