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
On Sun, May 30, 2010 at 6:05 AM, zhenyang guo
<concer.guo@gmail.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.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.