# Editions of PostgreSQL Supported for ODK Aggregate

**URL:** <https://forum.getodk.org/t/editions-of-postgresql-supported-for-odk-aggregate/2211>\
**Category:** Support\
**Created:** [May 17, 2013, 3:35am UTC](https://forum.getodk.org/t/editions-of-postgresql-supported-for-odk-aggregate/2211 "2013-05-17T03:35:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![EvanYates](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/e/a4c791/32.png) [@EvanYates](https://forum.getodk.org/u/EvanYates)\
**Post date:** [May 17, 2013, 3:35am UTC](https://forum.getodk.org/t/editions-of-postgresql-supported-for-odk-aggregate/2211/1 "2013-05-17T03:35:29Z")

</div>

Does ODK aggregate work with 64-bit PostgreSQL?  
We want to separate our ODK app server (Linux) from its PostgreSQL database  
server (Windows 2008) for security policy compliance reasons (No DBs in the  
DMZ). Should we use 32-bit or 64-bit PostgreSQL on the Windows server? Does  
it matter which? Does ODK support both versions because it is using the  
JDBC Spring connector?  
I've had a search around but no-one seems to specify whether 32-bit or  
64-bit is the way to go.

Thanks

Evan

---

<div class="post-metadata">

**Author:** ![Mitch\_S](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/3ec8ea/32.png) [@Mitch\_S](https://forum.getodk.org/u/Mitch_S)\
**Post date:** [May 17, 2013, 1:21pm UTC](https://forum.getodk.org/t/editions-of-postgresql-supported-for-odk-aggregate/2211/2 "2013-05-17T13:21:24Z")

</div>

It should work with both (the JDBC driver should hide this).

I am using the 64-bit PostgreSQL 9.1 server for testing.

Whether to use 32-bit or 64-bit depends upon your operating system. If the  
OS is a 64-bit OS, then use the 64-bit server.

Mitch

> **···**
>
> On Thu, May 16, 2013 at 8:35 PM, EvanYates wrote:
> 
> > Does ODK aggregate work with 64-bit PostgreSQL?  
> > We want to separate our ODK app server (Linux) from its PostgreSQL  
> > database server (Windows 2008) for security policy compliance reasons (No  
> > DBs in the DMZ). Should we use 32-bit or 64-bit PostgreSQL on the Windows  
> > server? Does it matter which? Does ODK support both versions because it is  
> > using the JDBC Spring connector?  
> > I've had a search around but no-one seems to specify whether 32-bit or  
> > 64-bit is the way to go.
> > 
> > Thanks
> > 
> > Evan
> > 
> > ## --
> > 
> > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)  
> > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com)  
> > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en)
> > 
> > * * *
> > 
> > You received this message because you are subscribed to the Google Groups  
> > "ODK Community" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).
> 
> --  
> Mitch Sundt  
> Software Engineer  
> University of Washington  
> [mitchellsundt@gmail.com](mailto:mitchellsundt@gmail.com)