Re: deployment query - Mailing list pgsql-general

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@kaltenbrunner.cc]
Sent: Tuesday, March 17, 2009 1:53 AM
To: Nagalingam, Karthikeyan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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