Re: Postgres size greater than 1TB
| От | Steve Midgley |
|---|---|
| Тема | Re: Postgres size greater than 1TB |
| Дата | |
| Msg-id | CAJexoSLYLB9QouRsTdxxLYtBY8Pm0hcOM0ynDH08ozT6WmMdSw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Postgres size greater than 1TB ("Rossi, Maria" <maria.rossi@jackson.com>) |
| Ответы |
RE: Postgres size greater than 1TB
RE: Postgres size greater than 1TB |
| Список | pgsql-sql |
On Thu, Dec 13, 2018 at 8:33 AM Rossi, Maria <maria.rossi@jackson.com> wrote:
Hi,
In the past, our postgres cluster data_directory is a file system that is < 1TB
Our postgresconf.cfg has this:
data_directory = '/dba/psg/gp08/pg_data'
Now, we need a new cluster that needs more than 1TB (Unix has a limit of 1TB for file systems)
Any suggestion on how to handle this?
Can I specify more than 1 path in my data_directory?
Can I create a tablespace in a new file system/directory?
1TB seems incredibly small these days as a file system limit - as Jesper says. If you're on a disk partition system with 1TB file limits (let alone for the whole file system!), you should consider upgrading your disk array and file system to a modern partition scheme, of which there are many choices on Linux/Unix type systems.
В списке pgsql-sql по дате отправления: