# Problem with db:create

**URL:** <https://www.ruby-forum.com/t/problem-with-db-create/193608>\
**Category:** Rails\
**Created:** [August 20, 2010, 1:30pm UTC](https://www.ruby-forum.com/t/problem-with-db-create/193608 "2010-08-20T13:30:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![upabibi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/e19adc/32.png) [@upabibi](https://www.ruby-forum.com/u/upabibi)\
**Post date:** [August 20, 2010, 1:30pm UTC](https://www.ruby-forum.com/t/problem-with-db-create/193608/1 "2010-08-20T13:30:40Z")

</div>

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