Re: Migrate from Oracle 12g to PostgreSQL 9.3

From: "Gust, Thorsten" <thorsten(dot)gust(at)spiegel(dot)de>
To: Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Migrate from Oracle 12g to PostgreSQL 9.3
Date: 2017-10-26 07:36:35
Message-ID: 176FEA9C-0845-4A5F-89DE-44F5D47107EE@spiegel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Ian, All,

Oops, many thanks for the very fast answers and sorry a mistake of mine, it’s 9.6.3 I’m running at the moment.

Thanks in advance and best regards
Thorsten

Thorsten Gust
IT-System Management

SPIEGEL-Verlag Rudolf Augstein GmbH & Co. KG
Ericusspitze 1
20457 Hamburg
Tel: +49 40 3007-2759
Fax: +49 40 3007-85 2759
E-Mail: thorsten(dot)gust(at)spiegel(dot)de

SPIEGEL-Verlag Rudolf Augstein GmbH & Co. KG, Sitz und Registergericht Hamburg HRA 61 755
Komplementärin Rudolf Augstein GmbH, Sitz und Registergericht Hamburg HRB 13 105
Geschäftsführer Thomas Hass


On 26.10.17, 04:18, "Ian Barwick" <ian(dot)barwick(at)2ndquadrant(dot)com> wrote:

On 10/25/2017 10:19 PM, Gust, Thorsten wrote:
> Hi All,
>
> I’m looking for a solution regarding migrate a user from Oracle DB to PostgreSQL
> having the same permissions, Tablespace Quota, Table Privileges, Roles and so on
> afterwards.
>
> Any help would be much appreciated!!

Out of interest, any reason why you're targetting PostgreSQL 9.3? It's currently
the oldest of the community-supported releases and will probably be EOL'd some
time in late 2018 [*]

[*] https://www.postgresql.org/support/versioning/

Regards

Ian Barwick

--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gust, Thorsten 2017-10-26 08:21:07 Re: Migrate from Oracle 12g to PostgreSQL 9.3
Previous Message Ian Barwick 2017-10-26 02:18:07 Re: Migrate from Oracle 12g to PostgreSQL 9.3