Streaming replication and partitions - Mailing list pgsql-admin

From Victor Tan
Subject Streaming replication and partitions
Date
Msg-id CANxEMJOuNMECD=Z2G0+WvQLMc41LPGUGM1vWz23wbR1Hg3GCyQ@mail.gmail.com
Whole thread Raw
Responses Re: Streaming replication and partitions  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
I am basically familiar with postgreSQL (in older incarnations) but have not really done a streaming replication (WAL) setup before.

In planning for my setup, I am going to use table partitioning and tablespaces to keep things as quick as "possible".  However, in a streaming replication environment, will the slave and the master have to be _exactly_ the same in terms of tablespaces?  Is it possible some TBSPACE01 on the master be on /sda1 and the same TBSPACE01 on the slave be on /sdb1?

Will I have to set up identical hardware and identical drives and directory structure between the master and slave?

Thanks.

- Victor Tan

pgsql-admin by date:

Previous
From: Oscar Calderon
Date:
Subject: Re: Migration of server
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Streaming replication and partitions