Thread: PostgreSQL support
Hi,
I am an experienced Oracle DBA and I am now working on building a PostgreSQL
database for a project. Part of the lure for this was the no-cost licensing
as we'll possibly be putting instances of this new system into many local
sites. At this time we are planning to build little logic into the database.
I will initially do hot backups on it, and will likely want to create a
standby cluster (using WAL logs) for high availability.
I'd like to know your opinions on support for PostgreSQL.
1. Do you think I should purchase commercial support (at least for the
initial development and release)?
2. Do you have recommendations on what companies are good and a good value?
3. Opinions on pay-per-incident vs. support agreements (am I likely to have
many issues I'll need support on - see my intro)?
4. Any other tips you can give me on having support for this project?
Your input would be appreciated.
Thanks,
Jed S. Walker
Hi Jed, On Wed, 2005-03-23 at 04:25 -0700, Walker, Jed S wrote: > I am an experienced Oracle DBA and I am now working on building a PostgreSQL > database for a project. Part of the lure for this was the no-cost licensing > as we'll possibly be putting instances of this new system into many local > sites. At this time we are planning to build little logic into the database. > I will initially do hot backups on it, and will likely want to create a > standby cluster (using WAL logs) for high availability. > > I'd like to know your opinions on support for PostgreSQL. > 1. Do you think I should purchase commercial support (at least for the > initial development and release)? > 2. Do you have recommendations on what companies are good and a good value? > 3. Opinions on pay-per-incident vs. support agreements (am I likely to have > many issues I'll need support on - see my intro)? > 4. Any other tips you can give me on having support for this project? 2ndQuadrant would be interested in supporting your use of hot backups and standby clustering. We offer services and support specifically aimed at your needs in that area. I can discuss contractual arrangements with you, if interested. Best Regards, Simon Riggs http://www.2ndquadrant.com/postgresql.html
Am Mittwoch, 23. März 2005 12:25 schrieb Walker, Jed S: > I'd like to know your opinions on support for PostgreSQL. > 1. Do you think I should purchase commercial support (at least for the > initial development and release)? > 2. Do you have recommendations on what companies are good and a good value? > 3. Opinions on pay-per-incident vs. support agreements (am I likely to have > many issues I'll need support on - see my intro)? > 4. Any other tips you can give me on having support for this project? Check out the companies offering support: http://techdocs.postgresql.org/companies.php In the end, only you can decide whether you actually need support. -- Peter Eisentraut http://developer.postgresql.org/~petere/
On Wed, 2005-03-23 at 05:25, Walker, Jed S wrote: > Hi, > > I am an experienced Oracle DBA and I am now working on building a PostgreSQL > database for a project. Part of the lure for this was the no-cost licensing > as we'll possibly be putting instances of this new system into many local > sites. At this time we are planning to build little logic into the database. > I will initially do hot backups on it, and will likely want to create a > standby cluster (using WAL logs) for high availability Look at Slony for non-WAL shipping replication and PITR for wal shipping. Both are quite useful, in different ways. I like Slony because I always have a live failover ready to go and it's nice to point long running report queries there so you're not loading your primary server down too much. PITR is nice in case things go horrible wrong and someone does something like delete from some table without a where clause. > I'd like to know your opinions on support for PostgreSQL. > 1. Do you think I should purchase commercial support (at least for the > initial development and release)? Not for initial development. Your Oracle experience will be both your blessing and your curse. I.e. your general database knowledge should be fine to get you up and running. Using Oracleisms (i.e. giving all the memory on the computer to postgres instead of letting the kernel do the caching etc...) might get in the way. Read up on tuning a pgsql server here: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html > 2. Do you have recommendations on what companies are good and a good value? Not really, I've never used them. But the ones that have folks here on the lists are the ones I'd go to first. > 4. Any other tips you can give me on having support for this project? The postgresql mailing lists are the best starting point. Search the archives.
Walker, Jed S wrote: >Hi, > >I am an experienced Oracle DBA and I am now working on building a PostgreSQL >database for a project. Part of the lure for this was the no-cost licensing >as we'll possibly be putting instances of this new system into many local >sites. At this time we are planning to build little logic into the database. >I will initially do hot backups on it, and will likely want to create a >standby cluster (using WAL logs) for high availability. > > You can use PITR, Mammoth Replicator or Slony for all of this. >I'd like to know your opinions on support for PostgreSQL. >1. Do you think I should purchase commercial support (at least for the >initial development and release)? > > Well I am biased because I lead one of the support companies but I think it really depends on your needs. Command Prompt (my company) provides everything from incident based support all the way up to full support and development contracts. Our incident based support is even available 24x7. Thus you can use us only when you need us. >2. Do you have recommendations on what companies are good and a good value? > > :) >3. Opinions on pay-per-incident vs. support agreements (am I likely to have >many issues I'll need support on - see my intro)? > > Again this depends on your needs. Incidents are great if you are only going to need a company a couple of times a year. If you find that you are using them as a Tier 3 every month for 5-10 hours then a support agreement may save you some money. >4. Any other tips you can give me on having support for this project? > > There are several good companies out there. Don't be afraid to ask for references. Sincerely, Joshua D. Drake Command Prompt, Inc. 503-667-4564 >Your input would be appreciated. > >Thanks, > > > Jed S. Walker > > > > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL