Обсуждение: Help on PostgreSQL
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?
2.Is there any enterprise version available with all features?
3.What are all best third party tools that we can use for development and administration?
4.What is the best way of resolving the issues or queries?
Thanks
Sarma
---------- Forwarded message ----------
From: Bruce Momjian <bruce@momjian.us>
Date: Mon, Oct 10, 2011 at 12:40 PM
Subject: Re: Help on Postgrase
To: cbssarma@gmail.com
Due to time constraints, I do not directly answer general PostgreSQL
questions. For assistance, please join the appropriate mailing list and
post your question:
http://www.postgresql.org/community
You can also try the #postgresql IRC channel on irc.freenode.net. See
the PostgreSQL FAQ for more information.
---------------------------------------------------------------------------
cbssarma@gmail.com wrote:
> Hi,
>
> 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?
>
> 2.Is there any enterprise version available with all features?
>
> 3.What are all best third party tools that we can use for development and administration?
>
> 4.What is the best way of resolving the issues or queries?
>
> Thanks
> Sarma
>
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From: Bruce Momjian <bruce@momjian.us>
Date: Mon, Oct 10, 2011 at 12:40 PM
Subject: Re: Help on Postgrase
To: cbssarma@gmail.com
Due to time constraints, I do not directly answer general PostgreSQL
questions. For assistance, please join the appropriate mailing list and
post your question:
http://www.postgresql.org/community
You can also try the #postgresql IRC channel on irc.freenode.net. See
the PostgreSQL FAQ for more information.
---------------------------------------------------------------------------
cbssarma@gmail.com wrote:
> Hi,
>
> 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?
>
> 2.Is there any enterprise version available with all features?
>
> 3.What are all best third party tools that we can use for development and administration?
>
> 4.What is the best way of resolving the issues or queries?
>
> Thanks
> Sarma
>
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
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
> 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.
> 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.
As Craig said, there are very good tools out which will help you migrating from Oracle to PostgreSQL, am adding one from my end i.e., EnterpriseDB
Migration Studio which comes in separate bundle.
---
Hello,
> 2.Is there any enterprise version available with all features?
We just completed migrating one of our products to PostgreSQL and load testing it. My suggestion- if your product uses stored procedures/packages heavily, have a look at EnterpriseDB. Otherwise, try plain simple PostgreSQL. That is what we did. We used ora2pg for database migration and orafce (http://pgfoundry.org/projects/orafce/) to minimize code changes. Since we did not have many procedures/packages it worked very well.
Regards,
Jayadevan
DISCLAIMER:
"The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."
> 2.Is there any enterprise version available with all features?
We just completed migrating one of our products to PostgreSQL and load testing it. My suggestion- if your product uses stored procedures/packages heavily, have a look at EnterpriseDB. Otherwise, try plain simple PostgreSQL. That is what we did. We used ora2pg for database migration and orafce (http://pgfoundry.org/projects/orafce/) to minimize code changes. Since we did not have many procedures/packages it worked very well.
Regards,
Jayadevan
DISCLAIMER:
"The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."