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