Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <scott.marlowe@xxxxxxxxx>
On Sat, May 29, 2010 at 6:35 PM, 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)


I think you're confusing the owner with the dbname.  there's not
postgres db.  you can create one:

psql template1
create database postgres;


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux