Postgres size greater than 1TB - Mailing list pgsql-sql

From Rossi, Maria
Subject Postgres size greater than 1TB
Date
Msg-id 7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com
Whole thread Raw
Responses Re: Postgres size greater than 1TB
Re: Postgres size greater than 1TB
Re: Postgres size greater than 1TB
Re: Postgres size greater than 1TB
List 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

 

pgsql-sql by date:

Previous
From: "agharta82@gmail.com"
Date:
Subject: Re: Group by column alias where same-column-name already exists
Next
From: Jesper Krogh
Date:
Subject: Re: Postgres size greater than 1TB