pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Streaming replication and partitions 2+ messages / 2 participants [nested] [flat]
* Streaming replication and partitions @ 2013-05-16 20:36 Victor Tan <victortcs@gmail.com> 2013-05-16 20:52 ` Re: Streaming replication and partitions Joshua D. Drake <jd@commandprompt.com> 0 siblings, 1 reply; 2+ messages in thread From: Victor Tan @ 2013-05-16 20:36 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Streaming replication and partitions 2013-05-16 20:36 Streaming replication and partitions Victor Tan <victortcs@gmail.com> @ 2013-05-16 20:52 ` Joshua D. Drake <jd@commandprompt.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2013-05-16 20:52 UTC (permalink / raw) To: Victor Tan <victortcs@gmail.com>; +Cc: pgsql-admin On 05/16/2013 01:36 PM, Victor Tan wrote: > 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? Yes, as long as sdb1 points to the same directory that sda1 on the other server points to. > > Will I have to set up identical hardware and identical drives and > directory structure between the master and slave? > Only in the sense of the database directories, tablespaces are directory specific. JD > Thanks. > > - Victor Tan -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC @cmdpromptinc - 509-416-6579 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-05-16 20:52 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2013-05-16 20:36 Streaming replication and partitions Victor Tan <victortcs@gmail.com> 2013-05-16 20:52 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox