Re: [ADMIN] Copy one database to another server

2013-05-02 Thread bricklen
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

Re: [ADMIN] Copy one database to another server

2013-05-02 Thread Steve Crawford
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

[ADMIN] Copy one database to another server

2013-05-02 Thread Huan Ruan
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

Re: [ADMIN] Migration from Sybase to Postgresql

2013-05-02 Thread Dev Kumkar
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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Vibhor Kumar
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

[ADMIN] Migration from Sybase to Postgresql

2013-05-02 Thread Dev Kumkar
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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread McKinzie, Alan (Alan)
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:

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Simpson, John (IMS)
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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Paul B. Anderson
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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Leonardo Carneiro
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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Vibhor Kumar
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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Prashanth Ranjalkar
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

Re: [ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Igor Neyman
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

[ADMIN] Migration from Oracle 11g to Postgresql

2013-05-02 Thread Silvana Bravo
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

Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD server

2013-05-02 Thread Jim Mercer
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