From: | Maarten Boekhold <maartenb(at)dutepp0(dot)et(dot)tudelft(dot)nl> |
---|---|
To: | Jason <neumeier(at)bright(dot)net> |
Cc: | "'psql'" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Different dB dir |
Date: | 1998-07-16 07:29:37 |
Message-ID: | Pine.SUN.3.91.980716092707.20505A-100000@dutepp0.et.tudelft.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 15 Jul 1998, Jason wrote:
> I have filled a partition on our Sparc with 6 databases. Each database
> is about 300MB in size. What I want to do is create future databases on
> a different partition. All current databases reside at
> /usr/local/pgsql/data/base/DBNAME
>
> The next time I create a dB, I want it to be at /platypus/pgsql/DBNAME
>
> Is this possible? And if so, how? I am running PostgreSQL 6.3 on a
> Sparc 20. Thanks in advance.
With PostgreSQL 6.3.2:
template1=> \h create database
Command: create database
Description: create a database
Syntax:
create database <dbname> [with location = '<dbpath>']
Also, 'man createdb' will give you answers.
Maarten
_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Maarten Boekhold | 1998-07-16 07:45:18 | Re: [INTERFACES] Re: [HACKERS] changes in 6.4 |
Previous Message | Fandarel | 1998-07-16 06:03:16 | Re: [GENERAL] null as a value |