Re: [GENERAL] hi，for help!

Hi,

Looks like, you accidentally deleted the postgresql database.
It can work without the postgres database, you just need to specify the
database name to work with.
i.e. psql test1

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>
On Sun, May 30, 2010 at 6:05 AM, zhenyang guo <concer(dot)guo(at)gmail(dot)com> wrote:

> 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(dot)vashi(at)enterprisedb(dot)com>
>
> [Adding pgsql-general...]
>> Please CC to pgsql-general..
>> (Use reply-all...)
>>
>> On Sat, May 29, 2010 at 2:31 PM, zhenyang guo <concer(dot)guo(at)gmail(dot)com>wrote:
>>
>>> hi,Ashesh, i did as you said ,it still gives problem. information from
>>> the terminal is following:
>>>
>>> " postgres(at)guo-desktop:~$ psql -l
>>>
>>> psql: FATAL: database "postgres" does not exist
>>>
>> What is the output of this command:
>> psql -l template1
>>
>>
>>
>>> postgres(at)guo-desktop:~$ psql --version
>>> psql (PostgreSQL) 8.4.4
>>> contains support for command-line editing
>>> postgres(at)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>
>>
>>
>