agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Rossi, Maria <maria.rossi@jackson.com>
To: 'pgsql-sql@lists.postgresql.org' <pgsql-sql@lists.postgresql.org>
To: 'pgsql-novice@lists.postgresql.org' <pgsql-novice@lists.postgresql.org>
Subject: Postgres size greater than 1TB
Date: Thu, 13 Dec 2018 16:33:03 +0000
Message-ID: <7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com> (raw)

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

view thread (4+ messages)  latest in thread

Message-ID: <7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com>
Permalink:  ../7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com/
Also on:    postgresql.org/message-id/7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: maria.rossi@jackson.com, pgsql-sql@lists.postgresql.org, pgsql-novice@lists.postgresql.org
  Subject: Re: Postgres size greater than 1TB
  In-Reply-To: <7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox