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

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(dot)marlowe(at)gmail(dot)com>

> On Sat, May 29, 2010 at 6:35 PM, zhenyang guo <concer(dot)guo(at)gmail(dot)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;
>