Re: PSQL under Windows XP

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