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
On Sun, May 30, 2010 at 6:05 AM, zhenyang guo <concer.guo@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx>[Adding pgsql-general...]Please CC to pgsql-general..(Use reply-all...)On Sat, May 29, 2010 at 2:31 PM, zhenyang guo <concer.guo@xxxxxxxxx> 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 existWhat is the output of this command:psql -l template1postgres@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.--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company
