Re: [GENERAL] hi，for help!

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.vashi@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.guo@gmail.com> wrote:

hi,Ashesh,  i did as you said ,it still gives problem. information from the terminal is following:

"     postgres@guo-desktop:~$ psql -l

psql: FATAL:  database "postgres" does not exist

What is the output of this command:

psql -l template1

 

postgres@guo-desktop:~$ psql --version
psql (PostgreSQL) 8.4.4
contains support for command-line editing
postgres@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