Re: Help on PostgreSQL

On Mon, Oct 10, 2011 at 8:25 PM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> 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