Thread: Extending PG_DATA

Hi,

Sorry if this seems a silly question from a novice.
However, I'm quite desperate for hints since I haven't
found from the archives.

Quoting from the documentation of 'postmaster', it can
only manage one DB cluster stored at a common file system.
In case the DB grows bigger and needs to use another
partition, how can this be achieved in PostgreSQL?

Actually, the target DB size is 5TB.  Any hints on its
configuration is highly appreciated.

Thanks in advance.

Best regards.
Ike

Dongon, Ike C. wrote:
> Quoting from the documentation of 'postmaster', it can
> only manage one DB cluster stored at a common file system.
> In case the DB grows bigger and needs to use another
> partition, how can this be achieved in PostgreSQL?

Use logical volume management (LVM) in your operating system, or
tablespaces in PostgreSQL.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/