RE: Postgres size greater than 1TB
"Rossi, Maria" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <de82d95e313d41919a6320bf4fa73cd2@DC03PXMBP003.jacksonnational.com> |
Sorry, my mistake. Should have asked our Unix support first, before I posted. Was told 1TB limit is old, we don’t have that issue now. Sorry. Maria From: Steve Midgley <[email protected]> Sent: Thursday, December 13, 2018 11:38 AM To: Rossi, Maria <[email protected]> Cc: [email protected]; [email protected] Subject: Re: Postgres size greater than 1TB EXTERNAL EMAIL On Thu, Dec 13, 2018 at 8:33 AM Rossi, Maria <[email protected]<mailto:[email protected]>> 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.