Re: postgreSQL & amazon ec2 cloud

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)
>
>
>