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) >>> 2010/5/29 Ashesh Vashi <ashesh.va...@enterprisedb.com> > [Adding pgsql-general...] > Please CC to pgsql-general.. > (Use reply-all...) > > On Sat, May 29, 2010 at 2:31 PM, zhenyang guo <concer....@gmail.com>wrote: > >> hi,Ashesh, i did as you said ,it still gives problem. information from >> the terminal is following: >> >> " postg...@guo-desktop:~$ psql -l >> >> psql: FATAL: database "postgres" does not exist >> > What is the output of this command: > psql -l template1 > > > >> postg...@guo-desktop:~$ psql --version >> psql (PostgreSQL) 8.4.4 >> contains support for command-line editing >> postg...@guo-desktop:~$ >> >> " >> it's kind of contradictory.and also in the phppgadmin interface i can't >> find the postgres either. >> > That's strange. > > -- > Thanks & Regards, > > Ashesh Vashi > EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com> > >