From: | Steve Midgley <science(at)misuse(dot)org> |
---|---|
To: | maria(dot)rossi(at)jackson(dot)com |
Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org, pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: Postgres size greater than 1TB |
Date: | 2018-12-13 16:38:00 |
Message-ID: | CAJexoSLYLB9QouRsTdxxLYtBY8Pm0hcOM0ynDH08ozT6WmMdSw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
On Thu, Dec 13, 2018 at 8:33 AM Rossi, Maria <maria(dot)rossi(at)jackson(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rossi, Maria | 2018-12-13 16:51:02 | RE: Postgres size greater than 1TB |
Previous Message | Jesper Krogh | 2018-12-13 16:36:28 | Re: Postgres size greater than 1TB |
From | Date | Subject | |
---|---|---|---|
Next Message | Rossi, Maria | 2018-12-13 16:51:02 | RE: Postgres size greater than 1TB |
Previous Message | Jesper Krogh | 2018-12-13 16:36:28 | Re: Postgres size greater than 1TB |