Re: Will This Work?
От | Matt Musgrove |
---|---|
Тема | Re: Will This Work? |
Дата | |
Msg-id | C0FE28B9352B6F4F8CE371643EC3B2515CCC464E@EFJDFWMB01.EFJDFW.local обсуждение исходный текст |
Ответ на | Will This Work? (Gene Poole <gene.poole@macys.com>) |
Список | pgsql-novice |
> From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Gene Poole > Sent: Wednesday, September 11, 2013 4:11 PM > To: pgsql-novice@postgresql.org > Cc: jpdsys2@comcast.net; etpoole60@comcast.net; jpdsys7@comcast.net; etpoole64@gmail.com; etpoole6465@gmail.com > Subject: [NOVICE] Will This Work? > > When I create a Oracle 11gR2 database we initially use the netca and dbca utilities to create the basic database filesand network connections. Afterwards we run a bash script to create the application database detail files. We use thisbash script to define certain files on specific raid-1 file systems. > How would we do this using PostgreSQL? What is the version of PostgreSQL you would suggest running on RHEL 5.9 x86_64?If I wanted to move from Oracle to PostgreSQL is it possible to use a Oracle export DMP file to load the PostgreSQLdatabase? > > Thanks, > Gene Poole My co-worker and I ported our application from Oracle to PostgreSQL. I can't answer your questions about netca or dbca created configuration files. I never really used either of those tools. We started from scratch with everything which is both a blessing and a curse (mostly a blessing). Obviously, it look uslonger than if we had used ora2pg or another tool to port the table structures. Now we have a better grasp of what PostgreSQLcan and cannot do. We were able to use PostgreSQL features that Oracle lacked. Also our stored functions are muchcleaner since they were all rewritten from scratch at the same time. We are also using RHEL 5.9 x86_64. We could have used the RPM's provided by the community but instead chose to install fromsource because it gives us more flexibility (our own version of Perl, binaries and data where we want them, etc). Westarted with 9.0 but switched to 9.1 partway through our conversion. We're running 9.2 now and will be moving to 9.3 soon.If I were in your shoes, I would start with 9.3. No, as far as I know, there is no way to use an Oracle dump file to load the PostgreSQL database. HTH, Matt Matthew Musgrove EF Johnson Technologies, Inc. Senior Software Engineer This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information.If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, youare hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attachedto this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notifyus by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them todisk. Thank you.
В списке pgsql-novice по дате отправления: