data files management (tablespaces)

From: "Victor Yegorov" <viktors(dot)jegorovs(at)nordlb(dot)lv>
To: "Postgres Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: data files management (tablespaces)
Date: 2003-05-18 06:47:48
Message-ID: 20030518064748.GA3241@nordlb.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello.

I wonder, is it possible in PostgreSQL to manage data files, stored on
disks? I mean, I'd like to tell DB where store this or that object.

Now I have a server running a DB and a small application that uses
it. At the time, when project started, there were enough space on HD
(4Gb). Now it seems, that soon I'm going to have problems.

At now, I'm daily backuping and then deleting all "expired" records. But
that is not the solution I want.

Is it possible to add one (or more) disks and tell Postgres to store, say,
indicies or big tables on them? Such things in ORACLE are called
tablespaces.

I've searched the docs, but found nothing apropriate, may be I've missed the
point.

I know, I can just upgrade hardware and move my stuff to the new server. But
still - is it possible to manage objects?

Thanks.

--

Victor Yegorov

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Együd Csaba 2003-05-18 08:16:28 Cygwin - Postgres won't start
Previous Message Bijoy Chandrasekharan 2003-05-17 16:41:13 Re: authentication error