Streaming replication and partitions

Поиск
Список
Период
Сортировка
От Victor Tan
Тема Streaming replication and partitions
Дата
Msg-id CANxEMJOuNMECD=Z2G0+WvQLMc41LPGUGM1vWz23wbR1Hg3GCyQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Streaming replication and partitions
Список 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 по дате отправления:

Предыдущее
От: Oscar Calderon
Дата:
Сообщение: Re: Migration of server
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Streaming replication and partitions