Postgres size greater than 1TB

Поиск
Список
Период
Сортировка
От Rossi, Maria
Тема Postgres size greater than 1TB
Дата
Msg-id 7a8352b4dbbb46878fe6e26ab96cec3d@DC03PXMBP003.jacksonnational.com
обсуждение исходный текст
Ответы Re: Postgres size greater than 1TB  (Jesper Krogh <jesper@krogh.cc>)
Re: Postgres size greater than 1TB  (Jesper Krogh <jesper@krogh.cc>)
Re: Postgres size greater than 1TB  (Steve Midgley <science@misuse.org>)
Re: Postgres size greater than 1TB  (Steve Midgley <science@misuse.org>)
Список 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 по дате отправления:

Предыдущее
От: "agharta82@gmail.com"
Дата:
Сообщение: Re: Group by column alias where same-column-name already exists
Следующее
От: Jesper Krogh
Дата:
Сообщение: Re: Postgres size greater than 1TB