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 <[email protected]>
> [Adding pgsql-general...]
> Please CC to pgsql-general..
> (Use reply-all...)
>
> On Sat, May 29, 2010 at 2:31 PM, zhenyang guo <[email protected]>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>
>
>
