Thread

1. Different dB dir

   Jason <neumeier@bright.net> — 1998-07-15T17:52:26Z

   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.
   
   -Jason.
   
   

2. Re: [GENERAL] Different dB dir

   Statistical Solutions <statsol@statsol.com> — 1998-07-15T19:05:28Z

   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
   > 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.
   > 
   > -Jason.
   > 
   > 
   
   
   

3. Re: [GENERAL] Different dB dir

   Maarten Boekhold <maartenb@dutepp0.et.tudelft.nl> — 1998-07-16T07:29:37Z

   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                         |
   -----------------------------------------------------------------------------