Thanks Stefan for all your answers. My last question is "What is the Mostly used Disaster Recovery Solution for Postgresql in storage environment." Regards Karthikeyan.N -----Original Message----- From: Stefan Kaltenbrunner [mailto:stefan@xxxxxxxxxxxxxxxx] Sent: Tuesday, March 17, 2009 1:53 AM To: Nagalingam, Karthikeyan Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: deployment query Nagalingam, Karthikeyan wrote: > Hi, > we are in the process of finding the best solution for Postgresql > deployment with storage controller. I have some query, Please give > some suggestion for the below > > 1) Can we get customer deployment scenarios for postgresql with > storage controller. Any flow diagram, operation diagram and > implementation diagram are welcome. well deployment is the same as for deploying it to plain old direct attached storage - so all the docs available on www.postgresql.org are more or less valid for this. > > 2) Which protocol is mostly used in production. [NFS,ISCSi,FCP,etc...] all of those are used - however NFS is quite often discouraged due to various reliability issues (mostly on the client side) and operational complexity that caused issues in the past. ISCSI and Fiberchannel deployments (both on netapp based storage and others) have worked very well for me. > > 3) What kind of application Mostly used with Postgresql. that is an extremely broad question - in doubt it is always "the application the customer uses". > > 4) What is the business and technical issues for Postgresql with > storage controller at present stage. not sure what a business issue would be here - but as for technical issues postgresql is comparable to the demands of other (commercial) databases in that regard. I personally found general tuning guidelines for storage arrays that got written for oracle to be pretty well suitable(within limits obviously) for postgresql too. > > 5) In which area Postgresql most wanted. it's the customer that counts :) > > 6) What kind of DR solution customer using for Postgresql with storage > controller. not sure what the question here is - maybe you can explain that in more detail? Stefan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
