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
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
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
on their machines
or would the interface connect directley to Postgresql - like a website??
Bob
- Original Message -
From: Stefano Nichele stefano.nich...@gmail.com
To: pgsql-general@postgresql.org
Sent: Monday, April 20, 2009 9:26 AM
Subject: Re: [GENERAL] postgreSQL amazon ec2 cloud
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
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
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
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 half ago
Tom Lane wrote:
Adrian Klaver akla...@comcast.net 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
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
On Tue, Mar 3, 2009 at 11:53 AM, Sanjay Arora sanjay.k.ar...@gmail.com 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 stu...@stuartbishop.net
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
not
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
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 postgreSQL?
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
Adrian Klaver akla...@comcast.net 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
On Tuesday 03 March 2009 7:25:17 am Tom Lane wrote:
Adrian Klaver akla...@comcast.net 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 Tue, Mar 03, 2009 at 10:25:17AM -0500, Tom Lane wrote:
Adrian Klaver akla...@comcast.net 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
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 akla...@comcast.net 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
Hello all
Is it possible to host postgreSQL on Amazon's cloud? What are the issues
involved?
With best regards.
Sanjay.
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
21 matches
Mail list logo