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

Re: PSQL under Windows XP

From: Danny Gaethofs <dgaethofs(at)yahoo(dot)com>
To: John DeSoi <desoi(at)pgedit(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org,Kevin Crenshaw <kcrenshaw(at)tiewireinc(dot)com>
Subject: Re: PSQL under Windows XP
Date: 2005-05-30 16:26:53
Message-ID: 20050530162653.97990.qmail@web54703.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
John,

PGADMINIII is not showing the template and template1
database but while browsing my directories I found in
the data\base directory two subdirectories 1 and
17229. Each time I create a new database a
subdirectory is added. So I assume these first two are
the template and template1 database directories.

Can I have directories for new databases created
elsewhere on my system.

Regards,
Danny
--- John DeSoi <desoi(at)pgedit(dot)com> wrote:
> 
> On May 30, 2005, at 10:20 AM, Danny Gaethofs wrote:
> 
> > I found this utility but I am having problems
> getting
> > it to work properly. I posted a message to the
> general
> > group about my problem.
> 
> See my response there.
> 
> >
> > I understand now that there are command line
> utilities
> > in the bin directory to perform some functions.
> >
> > You say you log on as the postgres user on the
> > template1 database.
> >
> > The template1 database, is it actually a database
> > which I should see when using PGADMINIII, cause at
> > current I do not see it.
> >
> > Let me say when I use PGADMINIII I am able to
> create a
> > database and specify whom is the owner.
> >
> 
> pgAdmin might hide them by default since they are
> generally only used  
> for creating databases. See
> 
>
http://www.postgresql.org/docs/8.0/interactive/manage-ag-
> 
> templatedbs.html
> 
> > But what I wanted to know is whether I can specify
> the
> > directory where my new database should appear.
> > I noticed that using createdb it is possible to
> > specify the location. Using PGADMINiii I do not
> see
> > the possibility.
> >
> > Am I correct?
> >
> 
> I don't see an option with createdb for directory.
> Do you mean  
> tablespace?
> 
> 
> 
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
> 
> 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Responses

pgsql-novice by date

Next:From: John DeSoiDate: 2005-05-30 16:41:16
Subject: Re: PSQL under Windows XP
Previous:From: John DeSoiDate: 2005-05-30 16:07:46
Subject: Re: PSQL under Windows XP

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