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