Re: Tablespace - PostgreSQL 9.2 - Mailing list pgsql-admin

From Alex Balashov
Subject Re: Tablespace - PostgreSQL 9.2
Date
Msg-id 57180ABE.1090208@evaristesys.com
Whole thread Raw
In response to Tablespace - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
List pgsql-admin
On 04/20/2016 07:00 PM, drum.lucas@gmail.com wrote:

> Setting a WHOLE table to start using tablespace in a different
> array/disks, do I have to have the same on the slaves, right?

No, the tablespace change will be propagated as a DDL change
automatically. What you _do_ have to do manually is to ensure the
physical storage directory for the tablespace(s) exists on both master
and slave.

--
Alex Balashov | Principal | Evariste Systems LLC
1447 Peachtree Street NE, Suite 700
Atlanta, GA 30309
United States

Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/


pgsql-admin by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: Tablespace - PostgreSQL 9.2
Next
From: rajan
Date:
Subject: Re: Partition table data are not found in the pg_dump backup