From KARTHIKEYAN.Nagalingam@netapp.com Mon Mar  16 07:00:58 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 7354B633B5D;
	Mon, 16 Mar 2009 09:47:31 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 10837-01; Mon, 16 Mar 2009 09:47:14 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mx2.netapp.com (mx2.netapp.com [216.240.18.37])
	by mail.postgresql.org (Postfix) with ESMTP id EB1346330E9;
	Mon, 16 Mar 2009 09:46:45 -0300 (ADT)
X-IronPort-AV: E=Sophos;i="4.38,372,1233561600";
	d="scan'208,217";a="141268368"
Received: from smtp1.corp.netapp.com ([10.57.156.124])
	by mx2-out.netapp.com with ESMTP; 16 Mar 2009 00:01:21 -0700
Received: from sacrsexc2-prd.hq.netapp.com (sacrsexc2-prd.hq.netapp.com
	[10.99.115.28])
	by smtp1.corp.netapp.com (8.13.1/8.13.1/NTAP-1.6) with ESMTP id
	n2G7149R016149; Mon, 16 Mar 2009 00:01:19 -0700 (PDT)
Received: from btcrsexc1-prd.hq.netapp.com ([10.73.251.109]) by
	sacrsexc2-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959);
	Mon, 16 Mar 2009 00:01:02 -0700
Received: from BTCMVEXC1-PRD.hq.netapp.com ([10.73.251.107]) by
	btcrsexc1-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959);
	Mon, 16 Mar 2009 12:30:59 +0530
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C9A604.F59B0B38"
Subject: deployment query 
Date: Mon, 16 Mar 2009 12:30:58 +0530
Message-ID: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: deployment query 
Thread-Index: AcmmBPU3x3b20GRmSd2o+qrQHaGS4w==
From: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
To: <pgsql-general@postgresql.org>, <pgsql-admin@postgresql.org>,
	<pgsql-performance@postgresql.org>
X-OriginalArrivalTime: 16 Mar 2009 07:00:59.0054 (UTC)
	FILETIME=[F5CA84E0:01C9A604]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200903/172
X-Sequence-Number: 31672

This is a multi-part message in MIME format.

------_=_NextPart_001_01C9A604.F59B0B38
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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
=20
1) Can we get customer deployment scenarios for postgresql with storage
controller. Any flow diagram, operation diagram and implementation
diagram are welcome.

2) Which protocol is mostly used in production. [NFS,ISCSi,FCP,etc...]

3) What kind of application Mostly used with Postgresql.

4) What is the business and technical issues for Postgresql with storage
controller at present stage.=20

5) In which area Postgresql most wanted.

6) What kind of DR solution customer using for Postgresql with storage
controller.=20

Thanks in advance, Any suggestion and recommendation are welcome.

Regards=20
Karthikeyan.N
=20
=20

------_=_NextPart_001_01C9A604.F59B0B38
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16788" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DVerdana size=3D2><SPAN=20
class=3D931205706-16032009>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2><SPAN =
class=3D931205706-16032009>&nbsp;&nbsp;&nbsp;=20
we are in the process of finding the best solution for Postgresql =
deployment=20
with storage controller. I have some query, Please give some suggestion =
for the=20
below</SPAN></FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2><SPAN=20
class=3D931205706-16032009></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN =
class=3D931205706-16032009>1) </SPAN>Can=20
we get customer deployment scenarios for postgresql with storage =
controller. Any=20
flow diagram, operation diagram and implementation diagram are=20
welcome.<BR><BR>2) Which protocol is mostly used in production.<SPAN=20
class=3D931205706-16032009> [NFS,ISCSi,FCP,etc...]</SPAN><BR><BR>3) What =
kind of=20
application Mostly used with Postgresql.<BR><BR>4) What is the business =
and=20
technical issues for Postgresql with storage controller at present =
stage.=20
<BR><BR>5) In which area Postgresql most wanted.<BR><BR>6) What kind of =
DR=20
solution customer using for Postgresql with storage controller.=20
</FONT></FONT><BR></DIV>
<DIV><SPAN class=3D931205706-16032009></SPAN><FONT face=3DVerdana><FONT=20
size=3D2>T<SPAN class=3D931205706-16032009>hanks in advance, Any =
suggestion and=20
recommendation are welcome.</SPAN></FONT></FONT><BR></DIV>
<DIV align=3Dleft><FONT face=3DVerdana size=3D2>Regards </FONT></DIV>
<DIV align=3Dleft><FONT face=3DVerdana =
size=3D2>Karthikeyan.N</FONT></DIV>
<DIV align=3Dleft><FONT face=3DVerdana size=3D2></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------_=_NextPart_001_01C9A604.F59B0B38--



From pierce@hogranch.com Mon Mar  16 17:38:05 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id DEBB5632D98
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Mon, 16 Mar 2009 14:38:40 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 88179-09
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Mon, 16 Mar 2009 14:38:36 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hogranch.com (hogranch.com [75.101.82.47])
	by mail.postgresql.org (Postfix) with ESMTP id 4BBA86325EE
	for <pgsql-general@postgresql.org>;
	Mon, 16 Mar 2009 14:38:34 -0300 (ADT)
Received: from [192.168.0.2] (porker [192.168.0.2])
	by hogranch.com (8.11.6/8.11.6) with ESMTP id n2GHc5I13871;
	Mon, 16 Mar 2009 10:38:05 -0700
Message-ID: <49BE8E7D.8020508@hogranch.com>
Date: Mon, 16 Mar 2009 10:38:05 -0700
From: John R Pierce <pierce@hogranch.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
To: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
CC: pgsql-general@postgresql.org
Subject: Re: deployment query
References: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
In-Reply-To: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-HawgScanner-Information: Please contact the ISP for more information
X-HawgScanner: Found to be clean
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/598
X-Sequence-Number: 145184

Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com> 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
>

Doesn't Network Appliance have anyone who could help you with this?      
This is the third time you've asked a set of incredibly broad general 
questions of this list, that level of information shopping would perhaps 
be best answered by a consulting service you would hire to do the task.  
An email list is more useful for answering specific questions, but can't 
really offer such broad advice given so little information. 

"storage controller' could mean anything from a simple SATA port on a 
desktop PC, to a EMC Symmetrix SAN, but we can guess based on your email 
address, you're specifically interested in NAS storage like Network 
Appliance Filers. 

"Customer Deployment Scenarios" ?!? 
    1) Install postgres. 
    2) Create database schema. 
    3) Deploy application(s).   

Protocol?  I'd venture a guess that the vast majority of postgres 
installations have direct attached JBOD or simple raid storage.   

What kind of application?   Any application requiring a relational 
database, ranging from web applications to accounting systems to 
manufacturing execution systems.  

I don't even know what to make of your questions 4 and 5.





From KARTHIKEYAN.Nagalingam@netapp.com Mon Mar  16 18:17:58 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 88362634A1C
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Mon, 16 Mar 2009 15:26:50 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 02820-01-7
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Mon, 16 Mar 2009 15:26:44 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mx2.netapp.com (mx2.netapp.com [216.240.18.37])
	by mail.postgresql.org (Postfix) with ESMTP id AE477634F6F
	for <pgsql-general@postgresql.org>;
	Mon, 16 Mar 2009 15:18:04 -0300 (ADT)
X-IronPort-AV: E=Sophos;i="4.38,374,1233561600"; d="scan'208";a="141506136"
Received: from smtp1.corp.netapp.com ([10.57.156.124])
	by mx2-out.netapp.com with ESMTP; 16 Mar 2009 11:18:03 -0700
Received: from sacrsexc1-prd.hq.netapp.com (sacrsexc1-prd.hq.netapp.com
	[10.99.115.27])
	by smtp1.corp.netapp.com (8.13.1/8.13.1/NTAP-1.6) with ESMTP id
	n2GII2ZD003570; Mon, 16 Mar 2009 11:18:02 -0700 (PDT)
Received: from btcrsexc1-prd.hq.netapp.com ([10.73.251.109]) by
	sacrsexc1-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959);
	Mon, 16 Mar 2009 11:18:02 -0700
Received: from BTCMVEXC1-PRD.hq.netapp.com ([10.73.251.107]) by
	btcrsexc1-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959);
	Mon, 16 Mar 2009 23:48:00 +0530
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: deployment query
Date: Mon, 16 Mar 2009 23:47:58 +0530
Message-ID: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303FD8FDA@BTCMVEXC1-PRD.hq.netapp.com>
In-Reply-To: <49BE8E7D.8020508@hogranch.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [GENERAL] deployment query
Thread-Index: AcmmXgq9LmoQksooS6mpe1pceGjfEgABXbjg
References: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
	<49BE8E7D.8020508@hogranch.com>
From: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
To: "John R Pierce" <pierce@hogranch.com>
Cc: <pgsql-general@postgresql.org>
X-OriginalArrivalTime: 16 Mar 2009 18:18:00.0033 (UTC)
	FILETIME=[89C80510:01C9A663]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200903/600
X-Sequence-Number: 145186

Thanks for your reply john.=20


Regards=20
Karthikeyan.N
=20

-----Original Message-----
From: John R Pierce [mailto:pierce@hogranch.com]=20
Sent: Monday, March 16, 2009 11:08 PM
To: Nagalingam, Karthikeyan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] deployment query

Nagalingam, Karthikeyan <KARTHIKEYAN.Nagalingam@netapp.com> wrote:
> Hi,
>     we are in the process of finding the best solution for Postgresql=20
> deployment with storage controller. I have some query, Please give=20
> some suggestion for the below
>

Doesn't Network Appliance have anyone who could help you with this?

This is the third time you've asked a set of incredibly broad general
questions of this list, that level of information shopping would perhaps
be best answered by a consulting service you would hire to do the task.

An email list is more useful for answering specific questions, but can't
really offer such broad advice given so little information.=20

"storage controller' could mean anything from a simple SATA port on a
desktop PC, to a EMC Symmetrix SAN, but we can guess based on your email
address, you're specifically interested in NAS storage like Network
Appliance Filers.=20

"Customer Deployment Scenarios" ?!?=20
    1) Install postgres.=20
    2) Create database schema.=20
    3) Deploy application(s).  =20

Protocol?  I'd venture a guess that the vast majority of postgres=20
installations have direct attached JBOD or simple raid storage.  =20

What kind of application?   Any application requiring a relational=20
database, ranging from web applications to accounting systems to
manufacturing execution systems. =20

I don't even know what to make of your questions 4 and 5.





From scott.marlowe@gmail.com Mon Mar  16 19:13:38 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 3F7BE632246;
	Mon, 16 Mar 2009 16:13:51 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 15075-01; Mon, 16 Mar 2009 16:13:43 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-qy0-f106.google.com (mail-qy0-f106.google.com
	[209.85.221.106])
	by mail.postgresql.org (Postfix) with ESMTP id 11E7063259C;
	Mon, 16 Mar 2009 16:13:41 -0300 (ADT)
Received: by qyk4 with SMTP id 4so1612753qyk.15
	for <multiple recipients>; Mon, 16 Mar 2009 12:13:39 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=Dh8xtAlmY4XXzu2MATWE7JFJ72Co145XL58C21Nhu6g=;
	b=GffCt1m8KmppTHTLy4PSnUn44+LnDrzFcyqEG33VbVn3ZJG0NzGJS7EcCkrnKr+sg0
	UqvEvoBzvWpQozZGivh7uaFScOdYqLp7tWy4oLXd4eb4+o27ShUUirDqIsLBQCi+zuaV
	76wK6SRbwMkLO8vlidwL8UX3oPBvgJ+UP6g0o=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=juKI+f4eN6iZffzlCWyYS67TANa+LFIDbIgxGNPRpNiQIGIijm5M0QTJLmjCCoYrhI
	rJPRvRJvCRAXzWE8tS1wzEiYKRuM1SJ+hmFnScDNr0G7JZTBFcywLRPcrhbO9bkPqfMp
	y7zFWMQryiphjKb6tiIExtgXJCFF4JlnQaby4=
MIME-Version: 1.0
Received: by 10.224.15.10 with SMTP id i10mr6082361qaa.11.1237230819231; Mon,
	16 Mar 2009 12:13:39 -0700 (PDT)
In-Reply-To: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
References: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
Date: Mon, 16 Mar 2009 13:13:38 -0600
Message-ID: <dcc563d10903161213j4c2786dan9a5fdb16154b0465@mail.gmail.com>
Subject: Re: deployment query
From: Scott Marlowe <scott.marlowe@gmail.com>
To: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org,
	pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/175
X-Sequence-Number: 31675

On Mon, Mar 16, 2009 at 1:00 AM, Nagalingam, Karthikeyan
<KARTHIKEYAN.Nagalingam@netapp.com> wrote:
> Hi,
> =A0=A0=A0 we are in the process of finding the best solution for Postgres=
ql
> 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 diagra=
m
> are welcome.

Like John said, install, initdb, configure postgresql.conf and
pg_hba.conf, load dbs and go.  Whether or not it's on a storage
controller is kind of not that big of a deal, as long as it's
reliable.

> 2) Which protocol is mostly used in production. [NFS,ISCSi,FCP,etc...]

If I can, I almost always build databases on DAS.  If I must use
something else, I'd lean towards iSCSI.  Don't trust NFS for
databases.

> 3) What kind of application Mostly used with Postgresql.

All kinds.  We mostly use it for Content Management where I work. Last
place I worked it was our primary database for RT (ticketing system),
bugzilla, media wiki, our statistical monitoring db, etc.  Our primary
lifting db was oracle, not because oracle was better, but because the
VC vultures wouldn't sign off on postgresql out of ignorance /
prejudice / lack of basic understanding / you name it.

> 4) What is the business and technical issues for Postgresql with storage
> controller at present stage.

Not sure what you're asking here.  Right now most postgresql
installations are on direct attached storage.  The biggest issues
affecting any deployment to remote storage are the ones having to do
with the OS postgresql is most often deployed on, Linux.  Device
drivers, iSCSI drivers, things like that.

I would think that if you wanted more traction for pgsql (or other
dbs) on netapp under linux, you could look at this area.

> 5) In which area Postgresql most wanted.

Got me.

> 6) What kind of DR solution customer using for Postgresql with storage
> controller.

First rule of communications, define your acronyms.  What's DR?



From stefan@kaltenbrunner.cc Mon Mar  16 20:22:36 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 3D8F6635049
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Mon, 16 Mar 2009 17:22:48 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 30580-05
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Mon, 16 Mar 2009 17:22:41 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from cronos.madness.at (madness.at [217.196.146.217])
	by mail.postgresql.org (Postfix) with ESMTP id EAAD2634AB7
	for <pgsql-general@postgresql.org>;
	Mon, 16 Mar 2009 17:22:45 -0300 (ADT)
Received: from mastermind.kaltenbrunner.cc ([83.215.233.60])
	by cronos.madness.at with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.69) (envelope-from <stefan@kaltenbrunner.cc>)
	id 1LjJKZ-0007ry-QJ; Mon, 16 Mar 2009 21:22:42 +0100
Message-ID: <49BEB50C.60708@kaltenbrunner.cc>
Date: Mon, 16 Mar 2009 21:22:36 +0100
From: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
User-Agent: Mozilla-Thunderbird 2.0.0.19 (X11/20090103)
MIME-Version: 1.0
To: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
CC: pgsql-general@postgresql.org
Subject: Re: deployment query
References: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
In-Reply-To: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.112 tagged_above=0 required=5 tests=AWL=0.112
X-Spam-Level: 
X-Archive-Number: 200903/606
X-Sequence-Number: 145192

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



From KARTHIKEYAN.Nagalingam@netapp.com Tue Mar  17 05:15:55 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 48ED7633107
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue, 17 Mar 2009 02:17:25 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 77864-03
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue, 17 Mar 2009 02:17:18 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mx2.netapp.com (mx2.netapp.com [216.240.18.37])
	by mail.postgresql.org (Postfix) with ESMTP id BD0BB6325EE
	for <pgsql-general@postgresql.org>;
	Tue, 17 Mar 2009 02:17:09 -0300 (ADT)
X-IronPort-AV: E=Sophos;i="4.38,376,1233561600"; d="scan'208";a="141711393"
Received: from smtp1.corp.netapp.com ([10.57.156.124])
	by mx2-out.netapp.com with ESMTP; 16 Mar 2009 22:17:07 -0700
Received: from sacrsexc2-prd.hq.netapp.com (sacrsexc2-prd.hq.netapp.com
	[10.99.115.28])
	by smtp1.corp.netapp.com (8.13.1/8.13.1/NTAP-1.6) with ESMTP id
	n2H5H7sV026220; Mon, 16 Mar 2009 22:17:07 -0700 (PDT)
Received: from btcrsexc1-prd.hq.netapp.com ([10.73.251.109]) by
	sacrsexc2-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959);
	Mon, 16 Mar 2009 22:17:07 -0700
Received: from BTCMVEXC1-PRD.hq.netapp.com ([10.73.251.107]) by
	btcrsexc1-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959);
	Tue, 17 Mar 2009 10:45:57 +0530
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: deployment query
Date: Tue, 17 Mar 2009 10:45:55 +0530
Message-ID: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303FD90CA@BTCMVEXC1-PRD.hq.netapp.com>
In-Reply-To: <49BEB50C.60708@kaltenbrunner.cc>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [GENERAL] deployment query
Thread-Index: AcmmdQh0XDABEFi4QtOX2JTLA8/cyQASh7wg
References: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
	<49BEB50C.60708@kaltenbrunner.cc>
From: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
To: "Stefan Kaltenbrunner" <stefan@kaltenbrunner.cc>
Cc: <pgsql-general@postgresql.org>
X-OriginalArrivalTime: 17 Mar 2009 05:15:57.0079 (UTC)
	FILETIME=[73EF3270:01C9A6BF]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200903/635
X-Sequence-Number: 145221

Thanks Stefan for all your answers. My last question is "What is the
Mostly used Disaster Recovery Solution for Postgresql in storage
environment."

Regards=20
Karthikeyan.N
=20

-----Original Message-----
From: Stefan Kaltenbrunner [mailto:stefan@kaltenbrunner.cc]=20
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=20
> deployment with storage controller. I have some query, Please give=20
> some suggestion for the below
> =20
> 1) Can we get customer deployment scenarios for postgresql with=20
> storage controller. Any flow diagram, operation diagram and=20
> 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.

>=20
> 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.


>=20
> 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".

>=20
> 4) What is the business and technical issues for Postgresql with=20
> 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.

>=20
> 5) In which area Postgresql most wanted.

it's the customer that counts :)

>=20
> 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



From scott.marlowe@gmail.com Tue Mar  17 05:26:23 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 5997A634863
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue, 17 Mar 2009 02:26:26 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 79845-07
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue, 17 Mar 2009 02:26:22 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.26])
	by mail.postgresql.org (Postfix) with ESMTP id 47CED633107
	for <pgsql-general@postgresql.org>;
	Tue, 17 Mar 2009 02:26:24 -0300 (ADT)
Received: by qw-out-2122.google.com with SMTP id 8so763090qwh.61
	for <pgsql-general@postgresql.org>;
	Mon, 16 Mar 2009 22:26:23 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=tG8fr5+Uuq0Bbe8DUw2BiqbqDwsQPgk/cfBFBq+NiiY=;
	b=RgLCwSmHSHPg8mJRd2vi7Ga0J6hKzSqigP8vvg+0CN65UEpJNVWlsr6uOCc67W211o
	jULsqLZ0UURghpGdzQLOW14JimzfcRbHLMe2qICFvh8EsM3R58ssqAa7z4lQbggLxd73
	aQBMhhkT2MVawhzgsjn9eViYiN/sSRJ2dWhP8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=vaKClXaZ0oWxWs4eDRC5ejoaUchAYExavYTxWdER5EdQcKuhFvH0y9DF+BelAH5D3x
	S6Cv2HZRm2wXRBbhrAsblFCenKWbHO4EKmJ7rlrPv6RXDq+JSEy/UqAo9lbbCHI7KAaX
	fCKwgnoSwDrOCjBo9OlyH6VhXBDnfY4X/7DN8=
MIME-Version: 1.0
Received: by 10.224.36.202 with SMTP id u10mr7088761qad.122.1237267583296;
	Mon, 16 Mar 2009 22:26:23 -0700 (PDT)
In-Reply-To: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303FD90CA@BTCMVEXC1-PRD.hq.netapp.com>
References: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
	<49BEB50C.60708@kaltenbrunner.cc>
	<5FFF8E9361C5D84EBBAF70C1931CDDE303FD90CA@BTCMVEXC1-PRD.hq.netapp.com>
Date: Mon, 16 Mar 2009 23:26:23 -0600
Message-ID: <dcc563d10903162226h1b301dd7gacada7c7c1eea4d4@mail.gmail.com>
Subject: Re: deployment query
From: Scott Marlowe <scott.marlowe@gmail.com>
To: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>,
	pgsql-general@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200903/636
X-Sequence-Number: 145222

On Mon, Mar 16, 2009 at 11:15 PM, Nagalingam, Karthikeyan
<KARTHIKEYAN.Nagalingam@netapp.com> wrote:
> Thanks Stefan for all your answers. My last question is "What is the
> Mostly used Disaster Recovery Solution for Postgresql in storage
> environment."

We use two methods of backup to keep the database afloat amid things
going horribly wrong.  We have 1 or more slony backup dbs that allow
for failover and load balancing.  We have offsite pg_dump backups
which are transferred via ssh to an offsite server in case of
catastrophic failure in the data center (like a huge power surge) that
kills both servers.

We routinely restore backup sets or parts of them for various testing scenarios.



From jd@commandprompt.com Tue Mar  17 05:45:41 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 350B5632246
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue, 17 Mar 2009 02:46:06 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 83677-05
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Tue, 17 Mar 2009 02:45:59 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from lists.commandprompt.com (host-159.commandprompt.net
	[207.173.203.159])
	by mail.postgresql.org (Postfix) with ESMTP id 3B9586310AC
	for <pgsql-general@postgresql.org>;
	Tue, 17 Mar 2009 02:45:55 -0300 (ADT)
Received: from [192.168.1.2] (or-69-34-217-90.sta.embarqhsd.net
 [69.34.217.90])
	(authenticated bits=0)
	by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id n2H5qT4V028773
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Mon, 16 Mar 2009 22:52:30 -0700
Subject: Re: deployment query
From: "Joshua D. Drake" <jd@commandprompt.com>
Reply-To: jd@commandprompt.com
To: "Nagalingam, Karthikeyan" <KARTHIKEYAN.Nagalingam@netapp.com>
Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>,
	pgsql-general@postgresql.org
In-Reply-To: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303FD90CA@BTCMVEXC1-PRD.hq.netapp.com>
References: 
 <5FFF8E9361C5D84EBBAF70C1931CDDE303D6C954@BTCMVEXC1-PRD.hq.netapp.com>
	<49BEB50C.60708@kaltenbrunner.cc>
	<5FFF8E9361C5D84EBBAF70C1931CDDE303FD90CA@BTCMVEXC1-PRD.hq.netapp.com>
Content-Type: text/plain
Organization: Command Prompt, Inc.
Date: Mon, 16 Mar 2009 22:45:41 -0700
Message-Id: <1237268741.6707.7.camel@jd-laptop.pragmaticzealot.org>
Mime-Version: 1.0
X-Mailer: Evolution 2.24.3 
Content-Transfer-Encoding: 7bit
X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0
	(lists.commandprompt.com [207.173.203.159]);
	Mon, 16 Mar 2009 22:52:30 -0700 (PDT)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200903/637
X-Sequence-Number: 145223

On Tue, 2009-03-17 at 10:45 +0530, Nagalingam, Karthikeyan wrote:
> Thanks Stefan for all your answers. My last question is "What is the
> Mostly used Disaster Recovery Solution for Postgresql in storage
> environment."

That vastly depends. The most common is likely warm standby (PITR). If
you are running Linux DRBD is a common solution as well. There is also
Slony-I, and Mammoth Replicator.

Joshua D. Drake

-- 
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997