Обсуждение: Extending PG_DATA

Поиск
Список
Период
Сортировка

Extending PG_DATA

От
"Dongon, Ike C."
Дата:
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

Re: Extending PG_DATA

От
Peter Eisentraut
Дата:
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/