Re: [GENERAL] Re: [GENERAL] hi，for help!

[zhenyang guo <concer.guo@xxxxxxxxx>]

hi ,it turn out i indeed deleted the postgres ,  and  with the  command "psql template1
create database postgres;  " i got my postgres.  
Scott   , Ashesh ,thanks for your both help .

2010/5/30 Scott Marlowe <scott.marlowe@xxxxxxxxx>

On Sat, May 29, 2010 at 6:35 PM, zhenyang guo <concer.guo@xxxxxxxxx> 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;