Databases on separate filesystems

From: "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com>
To: "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Databases on separate filesystems
Date: 2004-06-01 17:19:26
Message-ID: 82C3FD729CFA504CA44E7D32BDED411F0A2EF39A@lm-exmsg-07.lm.lmig.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to have each one of my PostgreSQL databases put on a separate
filesystem.

I wanted to do the following...can someone verify that this will work?

1) Create the following environment variables:
a. export PGDATA01=/filesystem1
b. export PGDATA02=/filesystem2
c. export PGDATA03=/filesystem3

2) Run the following commands at UNIX prompt:
a. initlocation /filesystem1
b. initlocation /filesystem2
c. initlocation /filesystem3

3) Restart my postgresql server (to pick up the new environment
variables)

4) Then when I create databases I would do this:
a. CREATE DATABASE mydb01 WITH LOCATION = 'PGDATA01';
b. CREATE DATABASE mydb02 WITH LOCATION = 'PGDATA02';
c. CREATE DATABASE mydb02 WITH LOCATION = 'PGDATA03';

Is this correct to get databases created on separate filesystems?

Thank you!

Troy Campano

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Schoen 2004-06-01 17:47:41 ORDER BY with plpgsql parameter
Previous Message Marc G. Fournier 2004-06-01 17:13:41 Re: Problems with pgsql mail servers?