Re: I can't get logged into the new improved metalink...
Date: Fri, 13 Nov 2009 21:49:51 +0000 (UTC)
On Thu, 12 Nov 2009 23:12:50 +0000, Palooka wrote:
> On 12/11/09 22:12, Mladen Gogala wrote:
>> On Thu, 12 Nov 2009 21:32:53 +0000, Palooka wrote:
>>> On 12/11/09 21:14, Mladen Gogala wrote:
>>>> On Thu, 12 Nov 2009 11:50:25 -0800, justalowlydba wrote:
>>>>> Is there a solution for this problem as I would like to get this
>>>> There is no solution which doesn't include the use of firearms.
>>> Like Gerard, I am looking at PostgreSQL. Seems easy as pie so far.
>> Me too. Are you in NYC?
> Nope, sorry. UK! > > Palooka
I've been working on PostgreSQL quite a bit for approximately 3 weeks now
and it's not quite that easy. There are no database links, there are no
distributed transactions or synonyms. Syntax of the PLPGSQL is quite
similar to the syntax of PL/SQL minus everything that starts with "DBMS_".
Partitioning is done in a very similar way to what is was on Oracle7: one
creates separate partition tables and then creates a rule or a trigger
which handles the insert.
Also, there is nothing like RAC, one has to scale horizontally and use shared-nothing architecture. I was successful with setting up backup and recovery and with doing replication using Slony-I. You are not the first person to mention Postgres and I have been quite busy with working on the PostgreSQL pilot. So, if there are people interested in exchanging experiences about transition from Oracle --> Postgres, please contact me at gogala.mladen_at_gmail.com