Thread: Help on PostgreSQL

On Mon, Oct 10, 2011 at 12:57:42PM +0100, Sarma Chavali wrote:
>  Could you please help us to find answers to the following questions?
>  1.What version of PostgreSQL is stable at the moment for production?

http://www.postgresql.org/ -> shows latest release 9.1.1.

>  2.Is there any enterprise version available with all features?

Yes/no. There is no enterprise PostgreSQL, but some companies are
extending PostgreSQL source, and providing modified version of Pg as
their product (this is perfectly acceptable and legal) - whether you'll
see it as enterprise version of postgresql, or separate product is up to
you.

>  3.What are all best third party tools that we can use for development and
> administration?

this I can't help with. for administration I use psql, and for
development vim.

>  4.What is the best way of resolving the issues or queries?

what kind of issues/queries?

if you have a problem, the simplest, and usually fastest way is to ask
on irc on channel #postgresql on irc.freenode.net

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

On 10 Říjen 2011, 16:50, hubert depesz lubaczewski wrote:
> On Mon, Oct 10, 2011 at 12:57:42PM +0100, Sarma Chavali wrote:
>>  Could you please help us to find answers to the following questions?
>>  1.What version of PostgreSQL is stable at the moment for production?
>
> http://www.postgresql.org/ -> shows latest release 9.1.1.

9.1 is really fresh, so if you're really conservative you may use 9.0
branch instead. That's about 1 year old.

>>  3.What are all best third party tools that we can use for development
>> and
>> administration?
>
> this I can't help with. for administration I use psql, and for
> development vim.

There are several useful tools I'm aware of - pgadmin (a nice GUI for
development / administration), phpPgAdmin (a web GUI), utilities like
pgfounine for analyzing slow queries, pgwatch for monitoring etc.

I know there were some GUI tools from EMS (http://www.sqlmanager.net) and
TOra (http://torasql.com). I guess there are other tools.

>>  4.What is the best way of resolving the issues or queries?
>
> what kind of issues/queries?
>
> if you have a problem, the simplest, and usually fastest way is to ask
> on irc on channel #postgresql on irc.freenode.net

That depends - if you're looking for help from other community members,
IRC or one of these mailing lists is probably the right place. If you're
looking for support (paid), there are companies that provide such
services.

regards
Tomas

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

--
Craig Ringer

On Mon, Oct 10, 2011 at 8:25 PM, Craig Ringer <ringerc@ringerc.id.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