On Thu, May 02, 2013 at 10:10:51AM +0300, Achilleas Mantzios wrote:
> Hi, i was just lurking around,
> being previously interested in running pgsql in jail environment (must have
> been some years back)
> i noticed that jails had issues with running many instances of postmaster
> listening on the
Hello, I'm planning a migration of production DBs from Oracle to
Postgresql. I would like to receive some suggestions, advising or links to
related subjects. I decided to rewrite all store procedures, that is not a
problem. But regarding the data I was thinking in migrating schema by
schema. First
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Silvana Bravo
Sent: Thursday, May 02, 2013 9:58 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Migration from Oracle 11g to Postgresql
Hello, I'm planning a migration of production DBs from Oracle
Yes, You can use the mentioned method by using scripts or also there are
few migration tools available to perform the migration of schema..
**
*Thanks & Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant & Architect*
*Email:prashant.ranjal...@gmail.com*
*Skype:prashanth.ranjalkar*
*www.p
On May 2, 2013, at 9:57 AM, Silvana Bravo wrote:
> Hello, I'm planning a migration of production DBs from Oracle to
> Postgresql. I would like to receive some suggestions, advising or links to
> related subjects. I decided to rewrite all store procedures, that is not a
> problem. But regarding
I used full convert to convert firebird DBs to postgresql. with a few
tweaks, works like a charm. never tried with oracle.
On Thu, May 2, 2013 at 11:09 AM, Vibhor Kumar wrote:
>
> On May 2, 2013, at 9:57 AM, Silvana Bravo wrote:
>
> > Hello, I'm planning a migration of production DBs from Orac
There is also ora2pg. I have not tried it but it looks easy.
http://ora2pg.darold.net/
On 5/2/13 10:18 AM, Leonardo Carneiro wrote:
I used full convert to convert firebird DBs to postgresql. with a few
tweaks, works like a charm. never tried with oracle.
On Thu, May 2, 2013 at 11:09 AM, Vib
I used Ora2Pg to migrate our production databases from Oracle 10g to Postgres a
couple years ago. It was extremely simple.
http://ora2pg.darold.net/
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Silvana Bravo
Sent: Thursday, May 02, 2013 9:58 AM
T
I used ora2pg a couple years ago. I made a few minor changes to fit our
specific requirements, but it worked well for our migration to Postgresql.
Alan
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Paul B. Anderson
Sent: Thursday, May 02, 2013 9:
Hello Everyone,
A similar related topic is being discussed and tools are suggested for
Oracle DB to Postgresql migration.
Here my objective is migration of Sybase DB to Postgresql.
Again stored procedures, triggers and functions will be manual approach.
For schema part please provide suggestions
On May 2, 2013, at 10:38 AM, "McKinzie, Alan (Alan)" wrote:
> I used ora2pg a couple years ago. I made a few minor changes to fit our
> specific requirements, but it worked well for our migration to Postgresql.
Ora2Pg is a good tool for one time migration.
However, when we come to crucial p
On Thu, May 2, 2013 at 8:12 PM, Dev Kumkar wrote:
> Hello Everyone,
>
> A similar related topic is being discussed and tools are suggested for
> Oracle DB to Postgresql migration.
>
> Here my objective is migration of Sybase DB to Postgresql.
>
> Again stored procedures, triggers and functions wi
Hi All
We are migrating from Firebird to Postgres. One task we frequently perform
is to copy one database from one server to another. It's easy to do in
Firebird as a database can basically be treated as a file (it shouldn't be
I know). This appears to be harder in Postgres, especially we will hav
On 05/02/2013 03:01 PM, Huan Ruan wrote:
Hi All
We are migrating from Firebird to Postgres. One task we frequently
perform is to copy one database from one server to another...
I think it would be helpful to know *why* you do this (backup,
forensics, development, shifting load among virtual ma
On Thu, May 2, 2013 at 3:01 PM, Huan Ruan wrote:
> create a new db using the current one as a template. Easy to do and speed
> is acceptable. A bit downtime is ok, but it's only on the current server.
> Is there a way to move it to anther server?
FWIW, I recently set up a 160GB clone by simply
15 matches
Mail list logo
