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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
Hello all
Is it possible to host postgreSQL on Amazon's cloud? What are the issues
involved?
With best regards.
Sanjay.
21 matches
Mail list logo