My ruby app always created the databases on postgres just fine, but, a
days ago, I’ve tried to create a new project and when I execute the
command “db:create:all” i got the following error:
Couldn’t create database for {“encoding”=>“unicode”, “username”=> “-my
username-”, “adapter”=>“postgresql”,
“database”=>“argh_development”, “host”=>“127.0.0.1”, “pool”=>5,
“password”=>"-my password-"}
NoMethodError: undefined method `fformat’ for #PGresult:0xb6706be0:
SHOW client_min_messages
What happens?
My database.yml is looking like this:
PostgreSQL. Versions 7.4 and 8.x are supported.
Install the ruby-postgres driver:
gem install ruby-postgres
On Mac OS X:
gem install ruby-postgres – --include=/usr/local/pgsql
On Windows:
gem install ruby-postgres
Choose the win32 build.
Install PostgreSQL and put its /bin directory on your path.
development:
adapter: postgresql
encoding: unicode
database: argh_development
pool: 5
username: ******
password: ******
host: 127.0.0.1
Connect on a TCP socket. Omitted by default since the client uses a
domain socket that doesn’t need configuration. Windows does not
have
domain sockets, so uncomment these lines.
#host: localhost
#port: 5432
Schema search path. The server defaults to $user,public
#schema_search_path: myapp,sharedapp,public
Minimum log levels, in increasing order:
debug5, debug4, debug3, debug2, debug1,
log, notice, warning, error, fatal, and panic
The server defaults to notice.
#min_messages: warning
Warning: The database defined as “test” will be erased and
re-generated from your development database when you run “rake”.
Do not set this db to the same as development or production.
test:
adapter: postgresql
encoding: unicode
database: argh_test
pool: 5
username: ******
password: ******
host: 127.0.0.1
Connect on a TCP socket. Omitted by default since the client uses a
domain socket that doesn’t need configuration. Windows does not
have
domain sockets, so uncomment these lines.
#host: localhost
#port: 5432
Schema search path. The server defaults to $user,public
#schema_search_path: myapp,sharedapp,public
Minimum log levels, in increasing order:
debug5, debug4, debug3, debug2, debug1,
log, notice, warning, error, fatal, and panic
The server defaults to notice.
#min_messages: warning
production:
adapter: postgresql
encoding: unicode
database: argh_production
pool: 5
username: ******
password: ******
host: 127.0.0.1
Connect on a TCP socket. Omitted by default since the client uses a
domain socket that doesn’t need configuration. Windows does not
have
domain sockets, so uncomment these lines.
#host: localhost
#port: 5432
Schema search path. The server defaults to $user,public
#schema_search_path: myapp,sharedapp,public
Minimum log levels, in increasing order:
debug5, debug4, debug3, debug2, debug1,
log, notice, warning, error, fatal, and panic
The server defaults to notice.
#min_messages: warning