Re: [GENERAL] Help on PostgreSQL
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."
Re: [GENERAL] 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. > > 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 http://www.enterprisedb.com/products-services-training/products/postgres-plus-advanced-server Migration Studio which comes in separate bundle. http://www.enterprisedb.com/downloads/add-on-components-bundles --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/
Re: [GENERAL] Help on PostgreSQL
On Mon, Oct 10, 2011 at 8:25 PM, Craig Ringer 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Help on PostgreSQL
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Help on PostgreSQL
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
