Different dB dir

er....try a symbolic link? (man ln) and just keep the schema in your
current DBDIR.

steve

On Wed, 15 Jul 1998, Jason wrote:

You know, sometimes it's the easy things that elude me! Thanks...

-----Original Message-----
From: Steve Doliov [mailto:statsol@statsol.com]
Sent: Wednesday, July 15, 1998 3:05 PM
To: Jason
Cc: 'psql'
Subject: Re: [GENERAL] Different dB dir

er....try a symbolic link? (man ln) and just keep the schema in your
current DBDIR.

steve

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

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.Boekhold@et.tudelft.nl |
-----------------------------------------------------------------------------