Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] hi,for help!

From: zhenyang guo <concer(dot)guo(at)gmail(dot)com>
To: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] hi,for help!
Date: 2010-05-30 00:35:41
Message-ID: AANLkTinPExSRvQbNOr32QML-S4qKf5qvMe_6rP8eQVhv@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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>
>
>

In response to

Responses

pgsql-general by date

Next:From: Justin GrafDate: 2010-05-30 01:20:01
Subject: Re: Installing version 8.4
Previous:From: Martin GaintyDate: 2010-05-30 00:21:08
Subject: Re: Installing version 8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group