Postgres size greater than 1TB

"Rossi, Maria" <[email protected]> Thu, 13 Dec 2018 16:33:03 +0000

Newsgroups	gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.novice
Message-ID	<7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com>

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