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....@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.va...@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....@gmail.com>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> >> >> >
