[GENERAL] Oracle to PostgreSQL transition?

2013-04-04 Thread Roy Anderson
Hey all, We have a very robust Oracle and SQL Server presence at work but we're looking to farm out some of the load to PostgreSQL to limit costs. I'm curious if there are any DBAs out there who have gone down this route before. Any tips, tricks, failures, successes, etc.? I would just like to hea

[GENERAL] Data Guard for Postgres?

2013-12-13 Thread Roy Anderson
Good day. I am inquiring as to whether there is a free solution available that approximates, in Postgres, what Data Guard does for Oracle DB. Can anyone advise? Thank you, Roy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

[GENERAL] Offending My Tender Sensibilities -OR- OLTP on a Star Schema

2014-02-06 Thread Roy Anderson
We have an OLTP database and no data warehouse. We are currently planning out a build for a data warehouse however (possibly using Hadoop). "X" is recommending that we convert our current, normalized OLTP database into a flattened Star Schema. The primary rationale for this OLTP flattening is that

[GENERAL] Materialized view from PG to Oracle?

2014-03-12 Thread Roy Anderson
Good day. We are transitioning over one database to Postgres as a test but retain an Oracle presence. The PG db in question is (it is currently still running Oracle) feeds a couple other Oracle dbs via materialized view logs and materialized views. Is it possible to achieve the same MV functionalit

Re: [GENERAL] Materialized view from PG to Oracle?

2014-03-16 Thread Roy Anderson
for my situation? Thank you for your time. I sincerely appreciate it. -Roy Anderson On Wed, Mar 12, 2014 at 9:28 AM, Ian Lawrence Barwick wrote: > 2014-03-12 12:00 GMT+09:00 Roy Anderson : > > Good day. We are transitioning over one database to Postgres as a test > but > > ret