| From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | Ravi Krishna <sravikrishna3(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to expand existing table-space |
| Date: | 2015-05-26 19:03:08 |
| Message-ID: | A76B25F2823E954C9E45E32FA49D70ECCD45D023@mail.corp.perceptron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Ravi Krishna
Sent: Tuesday, May 26, 2015 2:53 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] How to expand existing table-space
If the FS associated with the existing FS is reaching capacity, and sys-admins do not want to expand the FS any more and are advising us to use a new FS, what is the best practice in this case. Since PG does not have concept of adding data files to existing tablespace, how do we add space with no outage.
Thanks.
--
I see no other way, but create new TS on the new FS and move objects (all or some of them) from old into new TS.
Regards,
Igor Neyman
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2015-05-26 19:16:18 | Re: How to expand existing table-space |
| Previous Message | Ravi Krishna | 2015-05-26 18:52:43 | How to expand existing table-space |