OK, it works, i have not been create the database, i an newbie.

    #initdb -D ./mydb
    #postgres -D ./mydb
    #createdb mydb

following above command, then everything ok.

On Oct 12, 2:15 am, coolesting <[email protected]> wrote:
> Hi, guys
>
> I got this error
>
> $ rackup
> ==============================
> /home/app/ruby/lib/ruby/gems/1.9.1/gems/sequel-3.27.0/lib/sequel/adapters/postgres.rb:226:in
> `initialize': PGError: FATAL:  database "mydb" does not exist
> (Sequel::DatabaseConnectionError)
> from
> /home/app/ruby/lib/ruby/gems/1.9.1/gems/sequel-3.27.0/lib/sequel/adapters/postgres.rb:226:in
> `new'
> from
> /home/app/ruby/lib/ruby/gems/1.9.1/gems/sequel-3.27.0/lib/sequel/adapters/postgres.rb:226:in
> `connect'
> from
> /home/app/ruby/lib/ruby/gems/1.9.1/gems/sequel-3.27.0/lib/sequel/database/misc.rb:45:in
> `block in initialize'
> from
> /home/app/ruby/lib/ruby/gems/1.9.1/gems/sequel-3.27.0/lib/sequel/connection_pool.rb:92:in
> `call'
>
> I ensure the mydb in my project directory, and the 'ps aux | grep 'postgres'
> ' can gets the running process like this
> ===================================
>
> zcdny     6252  0.0  0.4  47020  4208 pts/0    S+   01:52   0:00 postgres -D
> ./mydb
> zcdny     6253  0.0  0.0  15192   916 ?        Ss   01:52   0:00 postgres:
> logger process
> zcdny     6255  0.0  0.1  47020  1340 ?        Ss   01:52   0:00 postgres:
> writer process
> zcdny     6256  0.0  0.1  47020  1112 ?        Ss   01:52   0:00 postgres:
> wal writer process
> zcdny     6257  0.0  0.1  47152  1244 ?        Ss   01:52   0:00 postgres:
> autovacuum launcher process
> zcdny     6258  0.0  0.0  15188  1024 ?        Ss   01:52   0:00 postgres:
> stats collector process
> zcdny     6383  0.0  0.0   4308   732 pts/1    S+   02:06   0:00 grep
> postgres
>
> my sequel connect
> =================================
>
> 'postgres://localhost/mydb?user=zcdny&password=123456'

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sequel-talk?hl=en.

Reply via email to