Re: postgreSQL & amazon ec2 cloud - Mailing list pgsql-general

From Stefano Nichele
Subject Re: postgreSQL & amazon ec2 cloud
Date
Msg-id 49ECD04B.1040609@gmail.com
Whole thread Raw
In response to Re: postgreSQL & amazon ec2 cloud  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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 and two EBS disks could be run on the same physical disk.....so
why to separate data and pg_xlog ? Is it still useful ? It 's like to
put data and pg_xlog on two partitions of the same disk.

Cheers,
ste


John R Pierce wrote:
> 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 environment if they were running Java
> applications.
>
>
>> or would the interface connect directley to Postgresql - like a
>> website??
>
> what 'interface' are you referring to ?  a client application can
> connect to a postgres server with the postgres protocol, by default
> over port 5432/tcp...  a client application would do this using libpq,
> or a native interface like jdbc (if the client is java)
>
>
>



pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: New 8.4 features
Next
From: jc_mich
Date:
Subject: Doubt about join queries