Search Postgresql Archives

Re: [GENERAL] hi,for help!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx>
[Adding pgsql-general...]
Please CC to pgsql-general..
(Use reply-all...)

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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux