Skip site navigation (1) Skip section navigation (2)

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

From: zhenyang guo <concer(dot)guo(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Re: [GENERAL] hi,for help!
Date: 2010-05-30 07:08:05
Message-ID: AANLkTik0kMjrJDHP-JswGZ89Az51PLpzUty6q2rKK5sB@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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(dot)marlowe(at)gmail(dot)com>

> On Sat, May 29, 2010 at 6:35 PM, zhenyang guo <concer(dot)guo(at)gmail(dot)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)
>
>
> I think you're confusing the owner with the dbname.  there's not
> postgres db.  you can create one:
>
> psql template1
> create database postgres;
>

In response to

pgsql-general by date

Next:From: Pavel StehuleDate: 2010-05-30 07:19:19
Subject: Re: vulnerability of COPY command
Previous:From: Dennis GearonDate: 2010-05-30 05:41:04
Subject: vulnerability of COPY command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group