agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rossi, Maria <maria.rossi@jackson.com>
To: Steve Midgley <science@misuse.org>
Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: RE: Postgres size greater than 1TB
Date: Thu, 13 Dec 2018 16:51:02 +0000
Message-ID: <de82d95e313d41919a6320bf4fa73cd2@DC03PXMBP003.jacksonnational.com> (raw)
In-Reply-To: <CAJexoSLYLB9QouRsTdxxLYtBY8Pm0hcOM0ynDH08ozT6WmMdSw@mail.gmail.com>
References: <7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com>
<CAJexoSLYLB9QouRsTdxxLYtBY8Pm0hcOM0ynDH08ozT6WmMdSw@mail.gmail.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 <science@misuse.org>
Sent: Thursday, December 13, 2018 11:38 AM
To: Rossi, Maria <maria.rossi@jackson.com>
Cc: pgsql-sql@lists.postgresql.org; pgsql-novice@lists.postgresql.org
Subject: Re: Postgres size greater than 1TB
EXTERNAL EMAIL
On Thu, Dec 13, 2018 at 8:33 AM Rossi, Maria <maria.rossi@jackson.com<mailto:maria.rossi@jackson.com>> 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.
view thread (4+ messages)
Message-ID: <de82d95e313d41919a6320bf4fa73cd2@DC03PXMBP003.jacksonnational.com>
Permalink: ../de82d95e313d41919a6320bf4fa73cd2@DC03PXMBP003.jacksonnational.com/
Also on: postgresql.org/message-id/de82d95e313d41919a6320bf4fa73cd2@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, science@misuse.org, pgsql-sql@lists.postgresql.org, pgsql-novice@lists.postgresql.org
Subject: RE: Postgres size greater than 1TB
In-Reply-To: <de82d95e313d41919a6320bf4fa73cd2@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