RE: Postgres size greater than 1TB

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.