On Sat, May 29, 2010 at 6:35 PM, zhenyang guo <concer.guo@gmail.com> wrote:
> hi ,i got a problem , kinda don't know how to deal with it ,hoping can get
> help here ,thanks !
> also to Ashesh ,firstly, thanks for every favor you did. and the postgres
> must exist ,maybe just present itself for some reason. when i give the
> command "
> psql -l template1 "
>
> it was there.
> <<<
> List of databases
> Name | Owner | Encoding | Collation | Ctype | Access
> privileges
> -----------+----------+----------+-------------+-------------+-----------------------
> template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
> :
> postgres=CTc/postgres
> template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
> :
> postgres=CTc/postgres
> test | guo1 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/guo1
> : guo1=CTc/guo1
> test1 | guo1 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/guo1
> : guo1=CTc/guo1
> :
> test1=CTc/guo1
> (4 rows)
I think you're confusing the owner with the dbname. there's not
postgres db. you can create one:
psql template1
create database postgres;