-----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Ravi Krishna Sent: Tuesday, May 26, 2015 2:53 PM To: pgsql-admin@xxxxxxxxxxxxxx Subject: 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
