Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-04-20 Thread Joshua Tolley
On Mon, Apr 20, 2009 at 02:14:00PM +0200, Stefano Nichele wrote: > Do you think that it could useful mounting two different EBS to handle > data and pg_xlog ? Testing I've participated in suggests that it helps to split pg_xlog elsewhere. Your mileage may vary. - Josh / eggyknap signature.asc

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-04-20 Thread Stefano Nichele
I'll run a java webapp running in tomcat connected to postgres via jdbc. BTW, why the access method should be important ? I mean, my main question is should pg_xlog be located on a different EBS than data ? My doubt is really about logical vs physical disk, since i think EBS is logical a

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-04-20 Thread John R Pierce
Bob Pawley wrote: From your experience could it be used in similar fashion as a website -> running a Postgresql database and having users access the database through an interface? If so, would the users need a Java environment installed on their machines ... um, the users would need a Java

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-04-20 Thread Bob Pawley
nstalled on their machines or would the interface connect directley to Postgresql - like a website?? Bob - Original Message - From: "Stefano Nichele" To: Sent: Monday, April 20, 2009 9:26 AM Subject: Re: [GENERAL] postgreSQL & amazon ec2 cloud Hi, I wanted to reply

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-04-20 Thread Ben Chobot
From the (very little) work I've done with EC2, it seems that what you get logically doesn't have much relation to what you get physically. I don't recall any guarentee that a virtual disk is equivilent to a physical spindle in terms of determining performance, or even that your virtual disk wi

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-04-20 Thread Stefano Nichele
Hi, I wanted to reply to an existing thread but it seems a new one has been created, so I think more details are required... I want to run my postgres DB on Amazon EC2 using a EBS persistent disk for postgres installation. In this way data and pg_xlog will be on the same disk. I was just wond

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-04-20 Thread Stefano Nichele
Do you think that it could useful mounting two different EBS to handle data and pg_xlog ? cheers, ste -- 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] postgreSQL & amazon ec2 cloud

2009-03-20 Thread Sleepless
Sanjay Arora wrote: > > Hello all > > Is it possible to host postgreSQL on Amazon's cloud? What are the issues > involved? > > With best regards. > Sanjay. > > You create postgres on EC2 in the same way you would on any Linux server. I created one on the Amazon-Fedora AMI about a year and h

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-19 Thread Ron Mayer
Tom Lane wrote: > Adrian Klaver writes: >> Nothing. I have created a Postgres instance on an EC2 virtual machine with >> attached EBS(Elastic Block Storage)..[...] > > ... I wonder whether you have any guarantees about database consistency > in that situation? PG has some pretty strong requirem

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-18 Thread Sanjay Arora
Thanks Stuart I will try Ubuntu image at Amazon cloud. Seems..they are looking for testers too. Not much of tester, but will be able to at least post to list if something fails ;-) Will try centos after that. With best regards. Sanjay Arora. On Tue, Mar 17, 2009 at 12:10 PM, Stuart Bishop wrote:

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-17 Thread Stuart Bishop
On Tue, Mar 3, 2009 at 11:53 AM, Sanjay Arora wrote: > Is it possible to host postgreSQL on Amazon's cloud? What are the issues > involved? Runs just fine under Ubuntu. We haven't tried it under serious load though. -- Stuart Bishop http://www.stuartbishop.net/ -- Sent via pgsql-general mai

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Erik Jones
On Mar 3, 2009, at 12:39 PM, Joshua Tolley wrote: On Tue, Mar 03, 2009 at 10:25:17AM -0500, Tom Lane wrote: Adrian Klaver writes: Nothing. I have created a Postgres instance on an EC2 virtual machine with attached EBS(Elastic Block Storage). I only got as far as creating in it and verifyi

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Joshua Tolley
On Tue, Mar 03, 2009 at 10:25:17AM -0500, Tom Lane wrote: > Adrian Klaver writes: > > Nothing. I have created a Postgres instance on an EC2 virtual machine with > > attached EBS(Elastic Block Storage). I only got as far as creating in it > > and > > verifying it would run, no benchmarking. EC2

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Adrian Klaver
On Tuesday 03 March 2009 7:25:17 am Tom Lane wrote: > Adrian Klaver writes: > > Nothing. I have created a Postgres instance on an EC2 virtual machine > > with attached EBS(Elastic Block Storage). I only got as far as creating > > in it and verifying it would run, no benchmarking. EC2 instances hav

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Tom Lane
Adrian Klaver writes: > Nothing. I have created a Postgres instance on an EC2 virtual machine with > attached EBS(Elastic Block Storage). I only got as far as creating in it and > verifying it would run, no benchmarking. EC2 instances have storage as part > of > the instance but it is temporar

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Oleg Bartunov
I don't know exactly, but here here is a paper from Elastra http://elastra.com/about/2008/03/07/enterprisedb-to-deliver-oltp-database-using-amazon-cloud/ Oleg On Tue, 3 Mar 2009, Sanjay Arora wrote: I found today that postgres EnterpriseDB supports Amazon EC2. On a shoestring budget Enterprise

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Adrian Klaver
On Tuesday 03 March 2009 4:41:48 am Sanjay Arora wrote: > I found today that postgres EnterpriseDB supports Amazon EC2. On a > shoestring budget EnterpriseDB is just as much an option as Oracle ;-( > > So, question is what makes EnterpriseDB more suitable for the cloud than > plain vanilla postgreS

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Sanjay Arora
I found today that postgres EnterpriseDB supports Amazon EC2. On a shoestring budget EnterpriseDB is just as much an option as Oracle ;-( So, question is what makes EnterpriseDB more suitable for the cloud than plain vanilla postgreSQL? Anyone? With best regards. Sanjay. On Tue, Mar 3, 2009 at

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-03 Thread Harald Armin Massa[legacy]
John, >> Is it possible to host postgreSQL on Amazon's cloud? What are the issues >> involved? > > in theory, sure.   anything is possible. > > in practice, as I understand it from my relatively superficial reading, fast > storage is fairly expensive and limited in the EC2 compute cloud, and also

Re: [GENERAL] postgreSQL & amazon ec2 cloud

2009-03-02 Thread John R Pierce
Sanjay Arora wrote: Hello all Is it possible to host postgreSQL on Amazon's cloud? What are the issues involved? in theory, sure. anything is possible. in practice, as I understand it from my relatively superficial reading, fast storage is fairly expensive and limited in the EC2 compute c

[GENERAL] postgreSQL & amazon ec2 cloud

2009-03-02 Thread Sanjay Arora
Hello all Is it possible to host postgreSQL on Amazon's cloud? What are the issues involved? With best regards. Sanjay.