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.
