| From: | "Rossi, Maria" <maria(dot)rossi(at)jackson(dot)com> |
|---|---|
| To: | "'pgsql-sql(at)lists(dot)postgresql(dot)org'" <pgsql-sql(at)lists(dot)postgresql(dot)org>, "'pgsql-novice(at)lists(dot)postgresql(dot)org'" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Postgres size greater than 1TB |
| Date: | 2018-12-13 16:33:03 |
| Message-ID: | 7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
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?
Any help would be appreciated.
Thanks
Maria
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jesper Krogh | 2018-12-13 16:36:28 | Re: Postgres size greater than 1TB |
| Previous Message | Laurenz Albe | 2018-12-10 11:13:26 | Re: [libpq] Async Queries and the Order of Execution |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jesper Krogh | 2018-12-13 16:36:28 | Re: Postgres size greater than 1TB |
| Previous Message | Ravi Krishna | 2018-12-13 00:16:50 | Re: explain analyze cost |