On Mon, Oct 10, 2011 at 8:25 PM, Craig Ringer <ringerc@xxxxxxxxxxxxx> wrote: > On 10/10/11 19:57, Sarma Chavali wrote: >> >> Hi Guys, >> >> We are new to PostgreSQL world. >> >> But, our company is planning to migrate the one of the existing >> application to PostgreSQL from Oracle. >> >> Could you please help us to find answers to the following questions? >> >> 1.What version of PostgreSQL is stable at the moment for production? > > The 9.1 series is relatively new, but in stable release. If you're still > in the planning stage for your migration you should certainly select 9.1 . > > Each major version has significant performance and feature enhancements. > It's usually best to start with the latest major release when beginning > a project. > >> 2.Is there any enterprise version available with all features? > > The free PostgreSQL comes with all available features; it's not a "lite" > version with paid "enterprise" add-ons. > > That said, there are separate companies that produce products based on > PostgreSQL. While many of these companies contribute to the PostgreSQL > core and are active members of the PostgreSQL community, they don't > control PostgreSQL. Any software they sell may be based on PostgreSQL, > but it's really a new and different product. These products add > additional functionality. One of the better-known is EnterpriseDB, who > have Pg variants with Oracle compatibility enhancements. > >> 3.What are all best third party tools that we can use for development >> and administration? > > http://www.postgresonline.com/journal/index.php?/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html > >> 4.What is the best way of resolving the issues or queries? > > If you're willing to put a little effort in, this mailing list will > often be able to help out. I'm not sure how much Oracle expertise there > is on the list, so Oracle-to-Pg migration questions may not get a great > response. > > If you want in-depth assistance with a project, especially with > migrations, you might be better off talking to one of the professional > consultants who work with PostgreSQL. Have a look at the list here: > > http://www.postgresql.org/support/professional_support > I'd also suggest starting at the postgresql wiki, specifically pages like this: http://wiki.postgresql.org/wiki/ http://wiki.postgresql.org/wiki/Performance_Optimization http://wiki.postgresql.org/wiki/Slow_Query_Questions http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Oracle http://wiki.postgresql.org/wiki/Database_Administration_and_Maintenance -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
