I realize it is not listed as a supported Database. I am interested to see if anyone has tried to install and use it.
there is simple answer here about supporting postgresql 9.
Will Esri support PostgreSQL 9 at 10.1?
Yes, PostgreSQL 9.0.2 will be supported at 10.1.
i hope it helps you...
Wait for ZigGIS 3.0 then you can edit without ArcSDE.
It's still in development.
I downloaded it but there is no "free" win exe for it yet. So I began to learn how to build it on my win xp machine and decided to stick with the supported esri sde install. (which states that you are to use the postgres install on the sde dvd. 8.3) So that is where I am now.
I haven't tried either, but worst case scenario, you should be able to use the ODBC drivers and connect to that DB.