Hello,
I'm designing a plan to upgrade from postgres 8.4. Our current setup includes three servers/dbs:
1. Production
2. Warm Standby (WAL shipping)
3. Reporting (built by ETL jobs)
I was hoping to have a similar setup with 9.0, but have the Reporting db maintained by replication instead of the ETL jobs. All the articles I read about Streaming replication tend to use the replicated box as a Hot Standby only... Is my setup possible? Know of any articles that will help me? Any suggestions of other ways I should design the reporting (ie. Greenplum)?
Here is the new setup I had in mind:
1. Production
2. Hot Standby
3. Reporting by Streaming Replication
Thanks!
I'm designing a plan to upgrade from postgres 8.4. Our current setup includes three servers/dbs:
1. Production
2. Warm Standby (WAL shipping)
3. Reporting (built by ETL jobs)
I was hoping to have a similar setup with 9.0, but have the Reporting db maintained by replication instead of the ETL jobs. All the articles I read about Streaming replication tend to use the replicated box as a Hot Standby only... Is my setup possible? Know of any articles that will help me? Any suggestions of other ways I should design the reporting (ie. Greenplum)?
Here is the new setup I had in mind:
1. Production
2. Hot Standby
3. Reporting by Streaming Replication
Thanks!