[GENERAL] Re: [GENERAL] Re: [GENERAL] hi,for help!

2010-05-30 Thread zhenyang guo
hi ,it turn out i indeed deleted the postgres , and with the command "psql template1 create database postgres; " i got my postgres. Scott , Ashesh ,thanks for your both help . 2010/5/30 Scott Marlowe > On Sat, May 29, 2010 at 6:35 PM, zhenyang guo > wrote: > > hi ,i got a problem , kinda

[GENERAL] Re: [GENERAL] Re: [GENERAL] hi,for help!

2010-05-29 Thread Scott Marlowe
On Sat, May 29, 2010 at 6:35 PM, zhenyang guo 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 giv

[GENERAL] Re: [GENERAL] hi,for help!

2010-05-29 Thread Ashesh Vashi
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 On

[GENERAL] Re: [GENERAL] hi,for help!

2010-05-29 Thread zhenyang guo
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. <<<

[GENERAL] Re: [GENERAL] hi,for help!

2010-05-29 Thread Ashesh Vashi
[Adding pgsql-general...] Please CC to pgsql-general.. (Use reply-all...) On Sat, May 29, 2010 at 2:31 PM, zhenyang guo 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: databa

[GENERAL] Re: [GENERAL] hi,for help!

2010-05-28 Thread Ashesh Vashi
What is the output of the following commands? psql -l psql --version -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Fri, May 28, 2010 at 7:11 PM, zhenyang guo wrote: > hi, i have a problem not knowing how to fix . the follwi

Re: [GENERAL] hi,for help!

2010-05-28 Thread Daniel Bausch
You need to "initdb" first. Am Freitag, 28. Mai 2010 15:41:38 schrieb zhenyang guo: > hi, i have a problem not knowing how to fix . the follwing are error > information: > > " > g...@guo-desktop:~$ su > Password: > r...@guo-desktop:/home/guo# su - postgres > postg...@guo-desktop:~$ psql > psql:

Re: [GENERAL] hi,for help!

2010-05-28 Thread Andreas Kretschmer
zhenyang guo wrote: > hi, i have a problem not knowing how to fix . the follwing are error > information: > > " > g...@guo-desktop:~$ su > Password: > r...@guo-desktop:/home/guo# su - postgres > postg...@guo-desktop:~$ psql > psql: FATAL: database "postgres" does not exist > postg...@guo-desk

[GENERAL] hi,for help!

2010-05-28 Thread zhenyang guo
hi, i have a problem not knowing how to fix . the follwing are error information: " g...@guo-desktop:~$ su Password: r...@guo-desktop:/home/guo# su - postgres postg...@guo-desktop:~$ psql psql: FATAL: database "postgres" does not exist postg...@guo-desktop:~$ createdb test createdb: could not c